How to add trendlines in Excel?
In this way, you can insert a very simple trendlines. You get more opportunities after selecting More Trendline Options button.
Then appears Format Trendline dialog box.
This dialog box gives you a lot of options to work with trendlines. For example, let’s see how it will look next 10 Forward Forecast periods for your sample trendline.
It’s just a very simple example but I’m sure you know how to add trend line and how to use trendline.
As you can see, the trendlines are pretty useful tool.