u Chart Template for Excel

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

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

The purpose of the u chart template is to determine stability of "counted" data (e.g., errors per widget, inquiries per month, etc.) when the sample size varies and you can have more than one defect per unit.

Here is an example of the u chart template in the QI Macros for Excel. Just type data into the yellow input area and the chart will be drawn to the right. You can also cut and paste data from another spreadsheet into the template.

The u chart template 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 template 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.

The u chart is used when the sample size varies: the number of circuit boards, meals, or bills delivered each day varies.

The u chart template is actually made up of several templates depending on your needs:

Just click on the appropriate worksheet tab to access any of these options:

• Center Line Based on Average (far left tab)
• Templates to Handle Rolling Data
• Short Run (DNOM) Control Charts
• u prime control chart
• Templates for Horizontal Data
• Control Chart with Fixed or Historical Control Limits

Other Resources

• u chart macro in excel
• u chart video
• u chart formula
• Other types of control charts

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

Order the template for Excel Mobile. Click Here.

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!