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 QI Macros Control Chart menu.
  2. moving-average-chart-menu

  3. 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