Microsoft Office Tutorials and References
In Depth Information
Tip If you don’t know which distribution to choose, use Linear. The other distributions are
used for scientific and engineering applications and you will know, or be told by a colleague,
when to use them.
After you pick the distribution type, you need to tell Excel how far ahead to project
the data trend. The horizontal axis of the chart used in this example shows revenues by
year from 2004 to 2009. To tell Excel how far in the future to look, type a number in the
Forecast area’s Forward box. In this case, to look ahead one year, type 1 in the Forward
box, and then click OK to add the trendline to the chart.
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.