Trying to Create XmR Median R Charts in Excel?

QI Macros can create them for you!

Create an XmR Median R Chart using QI Macros:

  1. Select your data.
  2. Click on QI Macros menu > Control Charts (SPC) > Special> XmR Median R.
  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 Median R Chart to Evaluate Stability of Processes Using Variable Data

The XmR Median R Chart works just like the XmR Chart except that it uses the median range instead of the average as a measure of central tendency. Out of control ranges inflate the average, where the median does not.

Here is an example of an XmR Median R Chart created using QI Macros for Excel.

XmR Median R chart created in Excel by QI Macros

The XmR Median R chart can help you evaluate data when the range chart is out of control. It is not as good as the average when ranges are in control. Only use the median range when you think the average range is inflated.

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

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

Learn More...

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