Microsoft Office Tutorials and References
In Depth Information
Finding trends in your data
TIP When you click the Trendline button in the Analysis group, one of the options Excel
displays is Linear Forecast Trendline, which adds a trendline with a two-period forecast.
As with other chart elements, you can double-click the trendline to open a formatting
dialog box and change the line’s appearance.
In this exercise, you’ll add a trendline to a chart.
SET UP You need the FutureVolumes workbook located in the Chapter09 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
Select the chart.
Click the Chart Elements action button, point to Trendline , click the right-pointing
triangle that appears, and then click More Options . The Format Trendline pane
If necessary, in the Trend/Regression Type area, click Linear .
In the Forecast area, in the Forward field, enter 3 .
Click the pane’s Close button to add the trendline to the chart.
CLEAN UP Close the FutureVolumes workbook, saving your changes if you want to.