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