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

Chapter 15. Using Regression to Track Tr... > Plotting an Exponential Trendline

Plotting an Exponential Trendline

The easiest way to see the trend and forecast is to add a trendline—specifically, an exponential trendline—to the chart. Here are the steps to follow:

1.
Activate the chart and, if more than one data series is plotted, click the series you want to work with.

2.
Choose Chart, Add Trendline to display the Add Trendline dialog box.

3.
On the Type tab, click Exponential.

4.
Select the Options tab and activate the Display Equation on Chart and Display R-Squared Value on Chart check boxes.

5.
Click OK. Excel inserts the trendline.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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