# Kibana Cateogry Coloring **URL:** \ **Category:** Kibana\ **Created:** [March 19, 2018, 7:50pm UTC](https://discuss.elastic.co/t/kibana-cateogry-coloring/124632 "2018-03-19T19:50:33Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Jatin\_Garg](https://avatars.discourse-cdn.com/v4/letter/j/f08c70/32.png) [@Jatin\_Garg](https://discuss.elastic.co/u/Jatin_Garg)\ **Post date:** [March 19, 2018, 7:50pm UTC](https://discuss.elastic.co/t/kibana-cateogry-coloring/124632/1 "2018-03-19T19:50:33Z")
Hi I am new to Kibana. I am sourcing data from sql using logstash and showing visualization on coordinates map in kibana using lat/lot points. I have data of two categories say x and y. How do i show them in different colors say x in red and y in green. Any help on this would be highly helpful. Thanks Jatin ---
**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\ **Post date:** [March 19, 2018, 8:49pm UTC](https://discuss.elastic.co/t/kibana-cateogry-coloring/124632/2 "2018-03-19T20:49:57Z")
Have you tried sub aggregations or followed through : [https://www.elastic.co/guide/en/kibana/current/xy-chart.html](https://www.elastic.co/guide/en/kibana/current/xy-chart.html) Once you’ve specified an X axis aggregation, you can define sub-aggregations to refine the visualization. Click + Add Sub Aggregation to define a sub-aggregation, then choose Split Area or Split Chart, then select a sub-aggregation from the list of types. Hope this helps, Cheers Rashmi ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 16, 2018, 8:50pm UTC](https://discuss.elastic.co/t/kibana-cateogry-coloring/124632/3 "2018-04-16T20:50:13Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.