XmR Hi-Lo Chart in Excel
Use the XmR Hi-Lo Chart template
Here is an example of an XmR Hi-Lo Chart template in Excel, created using QI Macros SPC Software:
* Note that the Average chart in this template includes Control Chart Limits (automatically calculated), along with Specification Limits that are entered manually in cells AP2 and AP4 *
To open this template, select the Control Chart Templates drop-down menu > Special (CUSUM, EWMA) > XmR Hi Lo Chart: