Add, remove, or change a trendline in PivotChart view
- Open a datasheet or form in PivotChart view.
- Do one or more of the following:
Add a trendline-
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.
-
On the PivotChart toolbar, click Properties
, and then click the General tab. -
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.
-
Click the trendline you want to delete.
-
Press DELETE.
-
Click the trendline you want to change.
-
On the PivotChart toolbar, click Properties
, and then click the Trendline tab. -
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.
-