Add a trendline to a data series

Microsoft Graph

Show All Show All

Add a trendline to a data series

  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 you add a moving average.