c Chart in Excel
Use a c chart for "counted" data when the opportunity is large compared to the actual number of defects.
The c chart is used to evaluate process stability when counting defects or errors and when the sample size is constant. For example injuries per month or falls per month.
C Chart example created by QI Macros for Excel.
c chart data consists of one column of integers:
To create a c chart in Excel using QI Macros:
- Just click and drag over the data to select it.
- Then click on the QI Macros menu, Control Charts, then c chart.
- QI Macros will all of the math and draw the c chart for you. QI Macros will also turn any unstable points or conditions on the c chart red. These should be investigated.
Learn More...
- Control Chart Quick Reference Card (PDF, 238 KB)
To create a C Chart using QI Macros...
To create a C Chart using QI Macros...
Join 100,000+ Users
in 80 Countries
Why Choose QI Macros?
Ease of Use
- Wizard Selects the Right Control Chart for You
- Save Time
- Accurate Results Without Worry
- Works Right in Excel XL2007-2016
Additional Features
- Turns Unstable Conditions Red
- Create Stair Step Limits
- Chart Menu Automates: Add Data, Target Lines, Recalc Limits, etc
- 1 Click Control Chart Dashboard
Affordable - Just $229 per license and less with Quantity Discounts
Variable Control Charts
XmR Individuals, X bar, X and S
Attribute Control Charts
c, p, np, u
Read What Others Say
- CNET Five Star Review
- Industry Leaders
