June 2001
Beginner
768 pages
20h 22m
English
You can display a trendline in unstacked area, bar, column, line, stock, XY (scatter), and bubble charts that don't have a 3D effect. A trendline creates a forecast of future trends based on existing data. For example, you can use a trendline to predict future revenues based on existing revenue data in a chart. This is also referred to as regression analysis.
You can use trendlines to make basic forecasts, but a solid understanding of regression analysis and statistics is necessary to make the best use of this feature. To create a trendline, follow these steps:
Choose Chart, Add Trendline to open the Add Trendline dialog box, shown in Figure 11.27.
Can't access ...