Attribute SPC Excel Template — P, nP, C and U Control Charts
Looking for a ready-to-use attribute SPC Excel template? This spreadsheet builds any of the four attribute control charts — P chart, nP chart, C chart or U chart — straight from your data, so you never have to guess which one you need.
⬇ Download the Attribute SPC Excel template
One template, four attribute control charts
Mark your data as defects or defectives with a single radio button, and the attribute SPC Excel template displays the correct chart automatically. It detects constant or varying sample sizes on its own and adjusts the control limits to match — no manual recalculation, and no picking the wrong chart. If you’ve ever been unsure whether you need a P, nP, C or U chart, this template makes the decision for you.
What the attribute SPC Excel template does
- Builds any of the four attribute control charts — P, nP, C or U — from a single dataset
- Detects constant and varying sample sizes automatically and sets control limits accordingly
- Evaluates up to 200 data points
- Applies all four Western Electric rules and highlights rule-violating points in colour
- Displays every control-chart statistic
- Accepts historical control limits, so you can judge a current process against a known baseline
Who it’s for
Quality engineers, Six Sigma practitioners and process-improvement teams working with pass/fail or count data who need a fast, correct attribute control chart in Excel — without building formulas from scratch.
Take it further
Once your chart flags a problem, the Attribute Sigma Calculator for Excel turns those same defect counts into DPMO and a process sigma level in seconds — a natural companion to this template.
I could not get Attribute SPC Excel Template to download.
The spc download is not working