Home » Control Charts » c Chart Template

Create a c Chart in Excel

Use c charts for counted data:
...when the opportunity is large but the number of defects is small

For example, you might be counting injuries at a plant or medication errors in a hospital. The opportunity for errors is large but the actual occurences are low.

Two Examples of c chart data

c chart data example in Excel

c chart in Excel created with the QI Macros software

It's Easy to Draw a c Chart in Excel Using QI Macros

QI Macros adds a new menu to Excel and provides two ways to create charts

Run a Macro on Data You Have Already Collected
Click and drag over the data to select it. Click on QI Macros > Control Charts > c chart. QI Macros does the math and draws the chart. QI Macros also performs stability analysis. Unstable points or trends turn red and should be investigated.
Watch a c chart created by a macro

Input Data into a Fill-in-the-Blanks Template
Click on QI Macros > Control Chart Templates > c chart. Input your data into the yellow shaded area. The chart is drawn as the data is input. Run stability analysis using the chart tools menu.
Example of QI Macros c chart template