Moving Average Chart Template in Excel

Use a Moving Average and Range chart when you have one sample and want a moving average.

QI Macros Moving Average Template Has Two Options:

1. Moving Average Chart

  • Input your data in column B
  • Indicate the # of data points you want included in the moving average in cell K2 (Moving Average Period).
  • Target (centerline) and standard deviation are calculated from your data but can be over written.

moving average control chart template excel

2. Wheeler Moving Average and Range

  • Input your data in column B
  • Indicate the # of data points you want included in the moving average in cell AA2 (Moving Average Period).
  • This template uses different calculations for the Moving Average chart and includes a Range chart, Histogram with Cp Cpk, Capability Plot and Probability Plot.

Wheeler moving average and range chart

Learn More...

To create a Moving Average Chart Template using QI Macros...
Try It Now!