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 examples

c chart in Excel

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

Just need one chart? Let us do it for you, only $97 Click Here!

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

Run a Macro on
Data You Have Already Collected

  1. Click and drag over the data to select it.
  2. Click on QI Macros > Control Charts > c chart.
  3. QI Macros does the math and draws the chart.
  4. QI Macros also performs stability analysis. Unstable points or trends turn red and should be investigated.

Watch a c chart created by a macro:

watch c chart created in Excel using QI Macros

Input Data into a
Fill-in-the-Blanks Template

  1. Click on QI Macros > Control Chart Templates > c chart.
  2. Input your data into the yellow shaded area.
  3. The chart is drawn as the data is input.
  4. Run stability analysis using the chart tools menu.

Example of QI Macros c chart template:

QI Macros c chart template in Excel

I just made my first charts and QI Macros were very easy and user friendly. This is going to be a great tool.

- Jim Welsh
Lennox Industries

Why Choose QI Macros Over Other Control Chart Software?



  • Only $279 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free

Learn More...