Trying to Create an I-MR-R Chart in Excel?
QI Macros can create them for you!
Go Deeper: The Individual Moving Range, Range Chart is a combination of the XbarR and XmR Chart. It gives both "within" group and "between" group variation. The I-MR-R Chart:
- Calculates the average of subgroups, just like an XbarR
- Creates the Range Chart (within group variation) just like the XbarR
- Creates a Moving Range Chart (between group variation) like an XmR using the average of the subgroups
- Creates the Individuals Chart like an XmR using the average of the subgroups
How to Create an I-MR-R Chart Using QI Macros Add-in for Excel:
- Select two or more columns of data.
- Click on the QI Macros tab installed on Excel's menu and, select Control Charts (SPC) > Variable (XmR, XbarR/S), and then "I-MR-R chart".
- QI Macros will do the math and draw the charts for you and turn unstable points or conditions red.
- Analyze and interpret the results:
- Evaluate the Range Charts first. If they are "out of control," so is the process. If the Range Charts look okay, then evaluate the X Chart.
- Investigate unstable points or trends.
Create a chart using an I-MR-R Chart template:
- Click on the QI Macros menu and select Control Chart Templates > Variable (XmR, XbarR/S) > I-MR-R.
- Input your data into the yellow shaded area.
- The chart is drawn as the data is input.
- Run stability analysis using the chart tools menu.

Stop Struggling with I-MR-R Charts!
Start creating your I-MR-R Charts in just minutes.
Download a free 30-day trial. Get I-MR-R Charts now!
Why Choose QI Macros Over Other Control Chart Software?
Fast and Easy to Use
- Works right in Excel
- Create charts in seconds
- Easy to customize & share charts
- Free Training Anytime
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free
Affordable
- Only $349 USD
Quantity Discounts Available - No annual subscription fees
- Free technical support