X-bar and R Control Chart Limits Worksheet
The X-bar and R chart is the workhorse of statistical process control for measured characteristics like diameters, thickness or torque. This worksheet does the arithmetic so you can focus on what the points say about your process.
| Subgroup | X1 | X2 | X3 | X4 | X5 | X-bar | Range | |
|---|---|---|---|---|---|---|---|---|
25.003 | 0.015 | |||||||
25.0044 | 0.014 | |||||||
25.001 | 0.012 | |||||||
25.0038 | 0.013 | |||||||
25.0034 | 0.01 | |||||||
25.0058 | 0.012 | |||||||
25.0024 | 0.009 | |||||||
25.0032 | 0.013 |
Limits are for subgroup size 5 (A2 0.577, D3 0, D4 2.114, d2 2.326). For other sizes use the control chart constants table and recompute. Use at least 20 to 25 subgroups before fixing limits, and replace the example rows with your own data.
Live SPC from shop floor data
Optional: describe your measurement capture and we can outline a private SPC feed from your ERP or MES.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Take small rational subgroups, for example five consecutive parts every half hour, and enter each as a row. The sheet computes the subgroup average and range, then the grand mean and R-bar, and from them the control limits for both charts. Replace the example rows with your readings and add rows as needed, aiming for at least 20 to 25 subgroups before treating the limits as stable. Export to Excel to plot the points against the lines.
- Keep readings in the same unit and decimal places.
- Subgroups should be collected close in time so variation inside is common-cause only.
- Review the R chart first, then the X-bar chart.
Formulas and constants
The centerline of the X-bar chart is the grand mean. Its limits are the grand mean plus or minus A2 times R-bar. The R chart has centerline R-bar, with UCL equal to D4 times R-bar and LCL equal to D3 times R-bar. For subgroup size 5, A2 is 0.577, D4 is 2.114 and D3 is 0. The within-subgroup sigma is R-bar divided by d2, which is 2.326 for n of 5. This sigma feeds Cp and Cpk, whereas the overall standard deviation feeds Pp and Ppk.
Interpreting the chart
Check the R chart first. If the range is out of control, the X-bar limits are unreliable because they depend on R-bar. Then look at the X-bar chart for points beyond the limits, runs of eight points on one side of the centerline, six points trending in one direction, or other Western Electric and Nelson patterns. Investigate each signal, record the assignable cause and recalculate limits only after removing points with confirmed special causes. Never draw spec limits on the X-bar chart as if they were control limits.
Common mistakes
Recalculating limits every day makes the chart follow the process and hide shifts. Using a subgroup that spans several machines or shifts inflates R-bar and widens the limits. Using the wrong constants for the subgroup size gives wrong limits, so check the table. Finally, remember that control limits come from the process voice, while specification limits are the customer voice.
Frequently Asked Questions
What subgroup size should I use?
Three to five is typical for X-bar and R charts. Larger subgroups detect smaller shifts but cost more to sample. For subgroup sizes above 10, an X-bar and S chart is preferred. This worksheet is built for five readings per subgroup.
Why check the R chart before the X-bar chart?
The X-bar limits are calculated from R-bar. If the variation within subgroups is unstable, R-bar is not a meaningful number, so the X-bar limits cannot be trusted. Bring the R chart into control first.
How many subgroups do I need to set limits?
A common guideline is 20 to 25 subgroups of size 4 to 5, giving 100 or more readings. With fewer, the limits are provisional and should be reviewed as more data arrive.
What is the difference between control limits and spec limits?
Control limits describe what the process is doing, calculated from its own data. Specification limits come from the drawing or customer. A process can be in control but incapable, or capable but out of control.
If your measurements are captured in an MES or ERP inspection module, we can help set up a private pipeline that feeds control charts and alerts without retyping data.
Related Tools
Control Chart Constants Table (A2, D3, D4, d2, c4)
Quick lookup of the factors used to build X-bar, R and S chart limits and to estimate sigma, for subgroup sizes 2 through 20.
Quality & InspectionPp Ppk Process Performance Calculator
Compute Pp and Ppk from overall standard deviation, compare them with Cp and Cpk from within-subgroup sigma, and estimate parts per million out of spec.
Quality & InspectionCpk Confidence Interval Calculator
Turn a single Cpk number and a sample size into a lower and upper confidence bound, and see how the interval narrows as sample size grows.
Quality & InspectionP Chart Control Limits Calculator
Enter total defectives, total inspected and subgroup size to get the p-bar centerline and control limits for a fraction defective chart.