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: Also read: How to Add Axis Titles in Charts in Excel? 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. Click on the plus icon – this appears when the chart is selected.Select the chart in which you want to add the trendline.Adding a Trendline in Line or Column Chartīelow are the steps to add a trendline to a chart in Excel 2013, 2016 and above versions: With the above chart, you can quickly make out that the trend is going up, despite a few bad weeks in footfall. If you plot this data in a line chart or column chart, you will see the data points to be fluctuating – as in some weeks the visitor numbers decreased as well.Ī trendline in this chart will help you quickly decipher the overall trend (even when there are ups and downs in your data points). You’ll find it in many charts where the overall intent is to see the trend that emerges from the existing data.įor example, suppose you have a dataset of weekly visitors in a theme park as shown below:
Adding Forecast Period to the TrendlineĪ trendline, as the name suggests, is a line that shows the trend.
0 kommentar(er)
