How Do I Create C-Charts in Excel Using SigmaXL?

C-Charts

1. Open Attribute Data - C Chart Defects.xlsx. C Charts (for Defects) assume a fixed subgroup size.


2. Select SigmaXL > Control Charts > Attribute Charts > C. Ensure that the entire data table is selected. If not, check Use Entire Data Table. Click Next.


3. Select Defects, click Numeric Data Variable (Y) >>. Check Tests for Special Causes.

   
   

   
   
4. Click OK. The resulting C-Chart is shown:



This is a stable process, with no tests for special causes flagged.