Moving Average Chart in Excel

Use a Moving Average Control Chart when there is only one sample and you want to evaluate process shifts using a simple moving average (i.e., not the EWMA).

Example of a Moving Average Chart created using QI Macros for Excel.

To create a moving average chart using QI Macros

1. Select your data and the Moving Average Excel chart from the QI Macros Control Chart menu.



2. Answer the prompt for the number of periods you want to use to calculate the moving average.



3. QI Macros will perform all of the calculations and will create a Moving Average Control Chart for you.

Learn More...

• EWMA Control Chart
• Cusum Control Chart
• Moving Average Chart video

• Control Chart Quick Reference Card (PDF, 238 KB)

To create a Moving Average Chart using QI Macros...