Using Trendlines

Spotting trends is a major use of charts and data. Graph 2000 uses formulas developed through the study of regression analysis to create trendlines.

Trendlines extend the actual data forward to predict a possible course. You can also test your trend analysis by extending the data backwards and comparing it against actual figures.

Trendlines can be used in a variety of chart types: unstacked area, bar, column, line, stock, xy (scatter), and bubble charts. However, you cannot add trendlines to a 3D, stacked, radar, pie, or doughnut chart. If you have trendlines in place and you convert your chart to one that does not support trendlines, the trendlines disappear.

It's easy to add a trendline to your chart. Choose Chart, Add Tr

Get Special Edition Using Microsoft® Word 2000 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.