Individuals & Moving Range Charts

  • Home /
  • Individuals & Moving Range Charts

How Do I Create Individuals & Moving Range Charts in Excel Using SigmaXL?



  1. Open Customer Data.xlsx, click on Sheet 1. Click SigmaXL > Control Charts > Individuals & Moving Range. Ensure that the entire data table is selected. If not, check Use Entire Data Table. Click Next.

  2. Select Overall Satisfaction, and click Numeric Data Variable (Y) >>. Ensure that Calculate Limits is selected.


    SigmaXL Individuals and Moving Range chart dialog with Overall Satisfaction selected as the numeric data variable


  3. Click OK. The resulting Individuals & Moving Range control chart:

  4. Individuals and Moving Range control chart created in Excel using SigmaXL

Define, Measure, Analyze, Improve, Control

SigmaXL statistical analysis software for Excel

Simulate, Optimize, Realize

DiscoverSim simulation and optimization software