Add, remove, or change a trendline in PivotChart view

1. Open a datasheet or form in PivotChart view.
2. Do one or more of the following:

Add a trendline

1. Click a data marker within the data series to which you want to add a trendline, and then click again to select the entire series.

2. On the PivotChart toolbar, click Properties , and then click the General tab.

3. Under Add, click Add Trendline .

Note   A linear trendline, its equation, and its R-squared value are placed on the series. Other trendline types include logarithmic, polynomial, power, exponential, and moving average.

Remove a trendline

1. Click the trendline you want to delete.

2. Press DELETE.

Change a trendline

1. Click the trendline you want to change.

2. On the PivotChart toolbar, click Properties , and then click the Trendline tab.

3. Do one or more of the following:

   • To change the trendline type, click the arrow next to the Type box and select a type in the list.

   • To change the order of a polynomial trendline, click the arrow next to the Order box and select from the list the number you want to be the highest power for the independent variable.

   • To change the trendline name, which appears in the legend, click the Custom Name check box under Name, and then type a new name in the box to the right.

   • To show or hide the equation you use to calculate the trendline, select or clear the Display equation check box.

   • To show or hide the R-squared value, select or clear the Display R-squared value check box.