Today, we want to learn how to add a trendline to a chart.
It’s a really simple task. We just have to select our chart, then press the green plus sign (Chart Elements) and go to the Trendline option. We can see that there are many types of trendlines, starting from Linear. Let’s use it (Fig. 1)
We can see that the trendline is of the same color as our columns, which we don’t want. Let’s click on our trendline, then press Ctrl + 1. In the Format Tredline window, we can see that we can modify it in many ways. Let’s click on the bucket icon, and change its color (Fig. 2
Now, I can see my trendline on the columns. When we select our trendline once more and press Ctrl + 1 again, we can even add an equation and some statistical information (Fig. 3)
If we don’t want it, we can press Delete. It’s important that the trendline doesn’t work with all chart types, only the most common ones, like a column chart or a line chart (Fig. 4)
