Change a trendline

Office Web Component Chart

Change a trendline

  1. In the design window, make sure the chart is activated. For instructions, see Help for your design program.
  2. Click the trendline you want to change.
  3. On the chart toolbar, click Commands and Options , and then click the Trendline tab.
  4. 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.