How many subgroups should a control chart template have?

Twenty-five is the usual choice: enough to compute reliable trial limits from one sheet. The template lets you choose 20, 25 or 30.

What subgroup size should I use on an X̄-R chart?

Four or five consecutive parts is the common choice: small enough to stay a rational subgroup, large enough for the averages to be close to normal. The sheet prints A₂, D₃ and D₄ for whichever size from 2 to 10 you pick.

Does the printed template work in Excel?

Use the CSV download for a spreadsheet. It opens in Excel, Google Sheets or LibreOffice with the subgroup and reading columns already laid out.

Free · No account

Printable Control Chart Template — X̄-R, I-MR and p Chart Data Sheets

A blank control chart sheet for the shop floor: header block, plotting grid, data table and the A₂, D₃, D₄ constants for your subgroup size, ready to print on A4 or Letter. Or download the same layout as a CSV to fill in a spreadsheet.

Chart

Subgroup size

Subgroups

Part (optional)

Characteristic (optional)

Prints landscape on one page. The CSV opens in Excel or Sheets and pastes back into the chart tool.

X̄-R control chart

Part

Characteristic

Spec / tolerance

Unit

Gauge

Samplen = 5, every

Operator

Dates

Subgroup	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25
Date
Time
x1
x2
x3
x4
x5
Sum
X̄
R

X̿ = ______ R̄ = ______

UCL(X̄) = X̿ + A₂R̄ = X̿ + 0.577·R̄ = ______

LCL(X̄) = X̿ − 0.577·R̄ = ______

UCL(R) = D₄R̄ = 2.114·R̄ = ______ LCL(R) = 0.000·R̄

Constants for n = 5: A₂ = 0.577, D₃ = 0.000, D₄ = 2.114, d₂ = 2.326. σ̂ = R̄/d₂. Compute limits after 20–25 subgroups; a point exactly on a limit is not a signal.

Everything on this page is calculated in your browser tab. Nothing you type is uploaded.

Using a paper chart

Fill in the header first — part, characteristic, specification, gauge and sampling plan — because a chart without it cannot be read by anyone who was not there. Record each subgroup in the data table, work out the average and range at the bottom of the column, and plot them as you go: the value of a paper chart is that the person running the process sees the signal while they can still act on it.

After 20 to 25 subgroups, compute X̿ and R̄ and draw the trial limits using the constants printed on the sheet, or type the columns into the X̄-R chart tool here and let it draw them. Investigate any point outside the trial limits before treating them as the baseline.

From paper to the chart tools

The CSV download has the same layout the chart tools read — one row per measurement with its subgroup number — so a sheet transcribed into a spreadsheet can be pasted straight into the X̄-R, I-MR or p chart tool for a figure with the limits, the constants and the run-rule set printed on it.

Common questions

How many subgroups should a control chart template have?: Twenty-five is the usual choice: enough to compute reliable trial limits from one sheet. The template lets you choose 20, 25 or 30.
What subgroup size should I use on an X̄-R chart?: Four or five consecutive parts is the common choice: small enough to stay a rational subgroup, large enough for the averages to be close to normal. The sheet prints A₂, D₃ and D₄ for whichever size from 2 to 10 you pick.
Does the printed template work in Excel?: Use the CSV download for a spreadsheet. It opens in Excel, Google Sheets or LibreOffice with the subgroup and reading columns already laid out.