However you do NOT have to do that calculation for an Excel Chart.

Or use the AVERAGE() function.Įxcel will show an error warning ‘Formula Omits Adjacent Cells’ which you can clear via ‘Ignore Error’.

Create a SUM() for the number of values you want (two in this case) and divide by the number of values then copy that formula down the column. Excel Moving averagesĬalculating a moving average is quite simple in Excel. The result is a two period moving average.Įxample: a series 1, 2, 3, 4, 1 the moving averages are 3, 5,7 and 5. For each value, take an average of the last, say, 2 values then do that for all the values. In statistics it’s one of the measures of central tendency.Ī moving average is great to see trends over time. Add all the values together and divide by the number of values.

Any chart with a series of values over time will benefit from a trendline like a moving average.Īn average / mean is a single value representing a list of numbers. Adding a moving average line to an Excel Chart is very easy, just a few clicks, with many options.

Power trend lines in excel 2016