Trying to Create XmR Control Charts in Excel?

QI Macros can create them for you!

Create an XmR Chart by running QI Macros:

  1. Select your data.
  2. Click on QI Macros menu > Control Charts (SPC) > Variable> XmR.
  3. QI Macros will do the math and draw the chart for you.
  4. QI Macros will also turn any unstable points or conditions red.

Go Deeper: Use an XmR Chart to Evaluate Stability of Processes Using Variable Data

Here is an example of an XmR chart created using QI Macros for Excel.

individual moving range XmR chart

XmR chart data examples:

XmR chart data may be a ratio of measurement.

x mr chart data example

The XmR chart can help you evaluate a process when there is only one sample and they are farther apart: monthly postage expense, time to write a computer program, and so on.

Calculate, plot, and evaluate the range chart first. If it is "out of control," so is the process. If the range chart looks okay, then calculate, plot, and evaluate the X chart.

XmR Multi-Column Chart

This functionality is used if you select the entirety of your data set that has multiple columns of data:

Sample Data for XmR Multi Column Chart

And then run the XmR (Individuals) Chart macro from the "Control Charts (SPC)" > "Variable (XmR, XbarR/S)" drop-down menu, an XmR (Individuals) Chart will be automatically created for you:

Chart Output of XmR Multi Column Data

NOTE: The chart will show a number of series - this represents the number of columns within your data set, with a blank row placed between each data series.

Stop Struggling with XmR Charts!
Start creating your XmR Charts in just minutes.

Download a free 30-day trial. Get XmR Charts now!

Why Choose QI Macros Over Other Control Chart Software?

easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free



  • Only $349 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support