Trend and trend line is a very useful feature of Excel. It is particularly very useful in predicting future data in accordance to current data.
Guide applies to office 2007 onwards
Forecast your data with trend line
- Arrange your data in a table and create a graph. We have created hypothetical weight growth chart of a baby. We have got 24 months data for weight series and 12 months data for actual series.
Now click on Insert tab and select line graph. Graph is ready
- To add a trend line Right click on actual line. Select option add trend line.
- Format Trend line window comes up. Select Linear from available option.
Click on OK, trend line will appear on our data series line