• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Working with Charts > Adding a Trendline

Adding a Trendline

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:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint