u Chart in Excel

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Copyright © 2009

Here is an example of a u chart created using the QI Macros SPC Software. The stair step or skyline control limits are the result of the varying sample sizes.

u chart data looks like this

The u chart will help evaluate process stability when there can be more than one defect per unit. Examples might include: the number of defective elements on a circuit board, the number of defects in a dining experience--order wrong, food too cold, check wrong, or the number of defects in bank statement, invoice, or bill.

The u chart is especially useful when you want to know how many defects there are not just how many defective items there are. It's one thing to know how many defective circuit boards, meals, statements, invoices, or bills there are; it is another thing to know how many defects were found in these defective items.

Video showing how to create a u chart in Excel

u chart template

u chart format options in the QI Macros

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Download
FREE
30-Day Trial

Or Buy It Now
for only $139!
Unconditional
90-Day
Money-Back
Guarantee