Leading the way in Microsoft Office Development

Excel

What is a Moving Average Trendline ?

Adding a Trendline

Type the number of periods to be used to calculate the moving average in the Period box.

Trendline Options

Things to Remember

If you add a moving average to a scatter chart the moving average is based on the order of the x-values plotted in the chart. To get the result that you want you might need to be sort the x-values before adding the trendline.