Add a trendline to a chart

Microsoft Office Excel 2003

Show All Show All

Add a trendline to a chart

  1. Click the data series to which you want to add a trendline or moving average.
  2. On the Chart menu, click Add Trendline.
  3. On the Type tab, click the type of regression trendline or moving average you want.
    • If you select Polynomial, enter in the Order box the highest power for the independent variable.

    • If you select Moving Average, enter in the Period box the number of periods to be used to calculate the moving average.

Notes

  • The Based on series box lists all the data series in the chart that support trendlines. To add a trendline to another series, click the name in the box, and then select the options you want.
  • If you add a moving average to an xy (scatter) chart, the moving average is based on the order of the x values plotted in the chart. To get the result you want, you might need to sort the x values before adding a moving average.