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:
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 (SPC) > Attribute (c,np,p,u,g,t) > c
- 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.
Input Data into a Fill-in-the-Blanks Template
- Click on QI Macros > Control Chart Templates > Attribute (c,np,p,u,g,t) > 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.
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
Why Choose QI Macros Over Other Control Chart Software?
- Only $299 USD - less with quantity discounts
- No annual subscription fees
- Free technical support
Easy to Use
- Works right in Excel
- Create a chart in seconds
- Easy to customize & share charts
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free