Draw a u Chart in Excel

Use u charts when counting defects and when the sample size varies


u chart data looks like this

u chart data example

Example of a u chart

u chart in Excel created with QI Macros software

Uneven control limits result from the varying sample sizes.


It's Easy to Draw a u Chart in Excel Using QI Macros

QI Macros adds a new menu to Excel and provides two ways to create charts: a u chart macro and a u chart template.

control chart in excel

I purchased the QI Macros just to run control charts (worth the price just for that). I had NO idea what a robust product you have developed, and what an amazing bargain I was getting. File me under exceeded customer expectations. 

- Scott Campbell
SwedishAmerican Hospital


Create a u chart by running a macro:

  1. Select your data.
  2. Select a u chart on QI Macros menu.
  3. QI Macros will do the math and draw the chart for you.
  4. QI Macros will also turn any unstable points or conditions red.
    These should be investigated.

Create a chart using a u chart template:

  1. Open a template :
    QI Macros > Control Chart Templates > u chart
  2. Input your data into the yellow shaded area.
  3. The chart is drawn as the data is input.
  4. Run stability analysis using the chart tools menu.
u chart template in Excel using the QI Macros software

What is the difference between defects and defective items?

Defects - u charts

Each item can have more than one defect:
defects

  • scratches on a car door
  • errors on a bill
  • missing products in a shipment

Defective Items - p charts

Each item is only counted once:
p chart of defective items

  • car doors that need to be repainted
  • bills that are wrong
  • incomplete shipments

Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • Only $249 - less with quantity discounts
  • No annual fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • 100,000 users in 80 countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus free

Learn More...