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.

1. Click the trendline you want to delete.

2. Press DELETE.

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.