# Linear trend in Bar Chart visualization Vega

**URL:** <https://discuss.elastic.co/t/linear-trend-in-bar-chart-visualization-vega/154979>\
**Category:** Kibana\
**Created:** [November 1, 2018, 9:13am UTC](https://discuss.elastic.co/t/linear-trend-in-bar-chart-visualization-vega/154979 "2018-11-01T09:13:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lidiya\_Chernova](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lidiya_chernova/32/21140_2.png) [@Lidiya\_Chernova](https://discuss.elastic.co/u/Lidiya_Chernova)\
**Post date:** [November 1, 2018, 9:13am UTC](https://discuss.elastic.co/t/linear-trend-in-bar-chart-visualization-vega/154979/1 "2018-11-01T09:13:31Z")

</div>

Hi guys! 👋

Could you please give a recommendation or an example how can I create a linear trends in my bar chart in Vega?  
Maybe there are some functions or templates that I can use?

Here is my graph:  
 ![trend](https://us1.discourse-cdn.com/elastic/original/3X/b/a/bab97fb5d5664fffa54c5688e2ce8c0752b1a9cd.png)

---

<div class="post-metadata">

**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:** [November 2, 2018, 3:20am UTC](https://discuss.elastic.co/t/linear-trend-in-bar-chart-visualization-vega/154979/2 "2018-11-02T03:20:56Z")

</div>

cc @nyuriks

Thanks  
Rashmi

---

<div class="post-metadata">

**Author:** ![nyuriks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nyuriks/32/26171_2.png) [@nyuriks](https://discuss.elastic.co/u/nyuriks)\
**Post date:** [November 2, 2018, 4:37pm UTC](https://discuss.elastic.co/t/linear-trend-in-bar-chart-visualization-vega/154979/3 "2018-11-02T16:37:01Z")

</div>

Hi, I am not aware of any ready-made transformations to help calculate trendline, but judging by [the formula](https://math.stackexchange.com/a/204021), it shouldn't be possible to manually do the needed calculation, and use a rule mark to draw it. I have posted this question in the Vega slack channel, and CCed you on it.

---

<div class="post-metadata">

**Author:** ![Lidiya\_Chernova](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lidiya_chernova/32/21140_2.png) [@Lidiya\_Chernova](https://discuss.elastic.co/u/Lidiya_Chernova)\
**Post date:** [November 12, 2018, 2:54pm UTC](https://discuss.elastic.co/t/linear-trend-in-bar-chart-visualization-vega/154979/4 "2018-11-12T14:54:38Z")

</div>

Thank you, Yuri. I will try to use a formula.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [December 10, 2018, 2:54pm UTC](https://discuss.elastic.co/t/linear-trend-in-bar-chart-visualization-vega/154979/5 "2018-12-10T14:54:38Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.