Individuals Moving Range (ImR - XmR) Chart in Excel
QI Macros has ImR-XmR Charts for Excel!
QI Macros can create them for you!
Create an ImR-XmR Chart by running QI Macros:
- Select your data.
- Click on QI Macros menu > Control Charts (SPC) > Variable> XmR
or Control Chart Wizard. - QI Macros will do the math and draw the chart for you.
- QI Macros will also turn any unstable points or conditions red.
Why It's Useful: Individual Moving Range Charts evaluate process stability using variable data—time, cost, length, weight—when your sample size is one.
Example of an Individual Moving Range Chart created using QI Macros for Excel.
Individuals Moving Range (XmR) Chart data examples
Data is organized as one column of ratios or measurements:
Rule: Evaluate the Range Chart first. If it is "out of control," that means the process variation is out of control.
The X Chart uses the average range (Rbar) to calculate its UCL and LCL. So, if the Range Chart is out of control, the calculations for the X Chart limits will be incorrect. If the Range Chart is in control, then 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:
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:
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.
Warning: include(/kunden/homepages/26/d362440150/htdocs/qimacros/includes/php/calltoaction-qimacros-tools.php): failed to open stream: No such file or directory in /homepages/26/d362440150/htdocs/qimacros/control-chart/individual-moving-range-xmr-chart/index.php on line 109
Warning: include(): Failed opening '/kunden/homepages/26/d362440150/htdocs/qimacros/includes/php/calltoaction-qimacros-tools.php' for inclusion (include_path='.:/usr/lib/php7.4') in /homepages/26/d362440150/htdocs/qimacros/control-chart/individual-moving-range-xmr-chart/index.php on line 109
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 $369 USD
Quantity Discounts Available - No annual subscription fees
- Free technical support