# Need to show Line chart like Similar to Excel in Kibana **URL:** \ **Category:** Kibana\ **Created:** [July 1, 2020, 4:30am UTC](https://discuss.elastic.co/t/need-to-show-line-chart-like-similar-to-excel-in-kibana/239401 "2020-07-01T04:30:45Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![lohit18](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lohit18/32/64131_2.png) [@lohit18](https://discuss.elastic.co/u/lohit18)\ **Post date:** [July 1, 2020, 4:30am UTC](https://discuss.elastic.co/t/need-to-show-line-chart-like-similar-to-excel-in-kibana/239401/1 "2020-07-01T04:30:45Z")
Hello Everyone, I have two columns X - Date Column ( 07/01/2020,06/01/2020,05/01/2020) Y- Value (145,160,1820) Similar to above points line chart should come ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/3/136f148bbc779a1fa80977a0331cce91ea73a176.png) But in kibana it is not showing like this. kindly help anyone how to do it ---
**Author:** ![defalt](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/defalt/32/71379_2.png) [@defalt](https://discuss.elastic.co/u/defalt)\ **Post date:** [July 1, 2020, 6:17am UTC](https://discuss.elastic.co/t/need-to-show-line-chart-like-similar-to-excel-in-kibana/239401/2 "2020-07-01T06:17:08Z")
Have a look at vega scatter plots. They should do the trick. ---
**Author:** ![lohit18](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lohit18/32/64131_2.png) [@lohit18](https://discuss.elastic.co/u/lohit18)\ **Post date:** [July 1, 2020, 6:39am UTC](https://discuss.elastic.co/t/need-to-show-line-chart-like-similar-to-excel-in-kibana/239401/3 "2020-07-01T06:39:38Z")
@defalt, Thanks can you share any links for vega scatter plots . ---
**Author:** ![defalt](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/defalt/32/71379_2.png) [@defalt](https://discuss.elastic.co/u/defalt)\ **Post date:** [July 1, 2020, 6:41am UTC](https://discuss.elastic.co/t/need-to-show-line-chart-like-similar-to-excel-in-kibana/239401/4 "2020-07-01T06:41:23Z")
> **[Scatterplot in Kibana using Vega](https://www.timroes.de/kibana-vega-scatterplot)** > > Tutorial on how to use Kibana's Vega visualization to create a scatter plot in > Kibana. [![](https://us1.discourse-cdn.com/elastic/original/3X/8/4/84d04dafc6593ecb856f925d55aea5009c484f5b.jpeg "scatter plot using kibana vega-lite || part 1") ](https://www.youtube.com/watch?v=5giacrHVYe4) > **[Scatter Plot Null Values Example](https://vega.github.io/vega/examples/scatter-plot-null-values/)** > > Vega - A Visualization Grammar. Vega is a visualization grammar, a declarative format for creating, saving, and sharing interactive visualization designs. With Vega, you can describe the visual appearance and interactive behavior of a visualization... ---
**Author:** ![lohit18](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lohit18/32/64131_2.png) [@lohit18](https://discuss.elastic.co/u/lohit18)\ **Post date:** [July 1, 2020, 6:44am UTC](https://discuss.elastic.co/t/need-to-show-line-chart-like-similar-to-excel-in-kibana/239401/5 "2020-07-01T06:44:10Z")
@defalt, Great will look into it . Thanks for update ---
**Author:** ![lohit18](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lohit18/32/64131_2.png) [@lohit18](https://discuss.elastic.co/u/lohit18)\ **Post date:** [July 1, 2020, 6:51am UTC](https://discuss.elastic.co/t/need-to-show-line-chart-like-similar-to-excel-in-kibana/239401/6 "2020-07-01T06:51:48Z")
@defalt Another question from my end .how can i show this X-Axis : Date Column Y-Axis: 3Categories (Mexico,LA,Boston) ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/4/64c3db407de23ae95a1b56fe62b32c9a13cde552.png) Kindly suggest me how to do .thanks for the support ---
**Author:** ![defalt](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/defalt/32/71379_2.png) [@defalt](https://discuss.elastic.co/u/defalt)\ **Post date:** [July 1, 2020, 7:11am UTC](https://discuss.elastic.co/t/need-to-show-line-chart-like-similar-to-excel-in-kibana/239401/7 "2020-07-01T07:11:51Z")
This is possible with kibana out of the box. Create an Area Visualization. ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/1/a16914746c453548d04074d9a4bbcb04f7ea979f.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/7/979c567cb203bc56879eff1adb46e2a6304ed7cc.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/6/d6839706859f8c822f147961489f6268aa20eeb9.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/9/790fabacd09bbb40ea2e23857e036cb93fdd3c46.png) ---
**Author:** ![lohit18](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lohit18/32/64131_2.png) [@lohit18](https://discuss.elastic.co/u/lohit18)\ **Post date:** [July 1, 2020, 7:28am UTC](https://discuss.elastic.co/t/need-to-show-line-chart-like-similar-to-excel-in-kibana/239401/8 "2020-07-01T07:28:00Z")
@defalt, Thanks for sharing info. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 29, 2020, 7:28am UTC](https://discuss.elastic.co/t/need-to-show-line-chart-like-similar-to-excel-in-kibana/239401/9 "2020-07-29T07:28:15Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.