XmR Target Chart in Excel
Use the XmR Target Chart to Define Your Control Limits
The centerline and control limits on a control chart are usually calculated from the data. However, in some instances you may want to evaluate a set of data against a baseline set of limits. The XmR Target template allows you to do this.
Just Input your Dates, Data, Target, USL and LSL in the Designated Cells
Input USL and LSL as shown in W4 and W6.
Input a baseline value in W12.
Input a Target Value in W15 and what label to start showing the target.
You can also specify a process change in W23.
Learn More...
- Individual Moving Range chart (XmR chart) template in Excel
- Individual Moving Range chart (XmR chart) video
- Individual Moving Range chart (XmR chart) formula
- Other Variable Control Charts in Excel