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.

simple moving average chart in Excel created with QI Macros software

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. moving-average-chart-menu

  3. Answer the prompt for the number of periods you want to use to calculate the moving average.
  4. number of periods input prompt for moving average chart

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

Learn More...

Why Choose QI Macros Over Other Control Chart Software?



  • Only $249 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • 100,000 users in 80 countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus free