This is often used to show the trend by considering an average of the specified number of periods.įor example, if you do a 3-part moving average, it will show you the trend based on the past three periods.
It will show you all the trendlines that you can use in Excel.Īpart from linear trendline, another useful option is a moving average trendline. click on the small triangle icon that appears when you click on the plus icon of the chart element. Here is a good article that explains what these trend lines are and when to use these. However, there are other variations as well that you can use: Types of Trendlines in Excelīy default, Excel inserts a linear trendline. In layman terms, a linear trendline is the best fit straight line that shows whether the data is trending up or down. The trendline that is added in the chart above is a linear trendline. That’s it! This will add the trendline to your chart (the steps will be the same for a line chart as well).Īnother way to add a trendline is to right-click on the series for which you want to insert the trendline and click on the ‘Add Trendline’ option.
0 kommentar(er)
