Change a trendline
- In the design window, make sure the chart is activated. For instructions, see Help for your design program.
- Click the trendline you want to change.
- On the chart toolbar, click Commands and Options , 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 that 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.