Create U-Charts

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

U-Charts


  1. Open Attribute Data U Chart Defects.xlsx. U Charts (for Defects) can have fixed or varying subgroup sizes.
  2. Select SigmaXL > Control Charts > Attribute Charts > U. 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) >>. Select N, click Subgroup Column or Size >>. Check Tests for Special Causes.
  4. SigmaXL U chart dialog with Defects selected as the numeric data variable and N selected as the subgroup size
  5. Click OK. The resulting U-Chart is shown:
  6. Completed U chart in Excel showing a stable process with no special cause tests flagged

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

Define, Measure, Analyze, Improve, Control

SigmaXL statistical analysis software for Excel

Simulate, Optimize, Realize

DiscoverSim simulation and optimization software