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

Chapter 15. Using Regression to Track Tr... > Plotting a Polynomial Trendline

Plotting a Polynomial Trendline

Here are the steps to follow to add a polynomial trendline to a chart:

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 Polynomial.

4.
Use the Order spin box to choose the order of the polynomial equation you want.

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

6.
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