Individuals Moving Range (ImR - XmR) Chart in Excel

Use an Individual Moving Range Chart to evaluate stability of processes 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

Individuals Moving Range (XmR) Chart data examples

Data is organized as one column of ratios or measurements:

individual moving range chart xmr chart data example

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.

Why Choose QI Macros Over Other Control Chart Software?



  • Only $299 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

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