Using Trendlines
Spotting trends is a major use of charts and data. Trendlines extend your actual data forward to predict where future data points may fall. You can also test your data and analysis by extending the data backward and comparing it against actual, older figures.
Trendlines can be used in various 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 Trendlines. (If Add Trendlines is not active, your chart type doesn't support this ...
Get Special Edition Using® Microsoft® Office Word 2003 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.
