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
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access