Add a trendline to a chart
- Click the data series to which you want to add a trendline or moving average.
- On the Chart menu, click Add Trendline.
- 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.