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
- Select your data and the Moving Average Excel chart from the QI Macros Control Chart menu.
- Answer the prompt for the number of periods you want to use to calculate the moving average.
- QI Macros will perform all of the calculations and will create a Moving Average Control Chart for you.
Learn More...
- Control Chart Quick Reference Card (PDF, 238 KB)
Why Choose QI Macros Over Other Control Chart Software?
Affordable
- Only $249 USD - less with quantity discounts
- No annual subscription fees
- Free technical support
Easy to Use
- Works right in Excel
- Create a chart in seconds
- Easy to customize & share charts
Proven and Trusted
- 100,000 users in 80 countries
- Celebrating 20th Anniversary
- Five Star CNET Rating - Virus free
