Draw a u Chart in Excel

Use u charts when counting defects and the sample size varies

u chart data looks like this:

u chart data

Example of a u chart:

u chart in excel

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:


I purchased 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 excel

What is the difference between defects and defective items?

Defects - u charts

Each item can have more than one defect:

  • 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

Change the Y-Axis Multiplier:

  • Located to the right of the chart, this functionality allows you to change the multiplier. This automatically changes the y-axis value (e.g. 1, 10, 100, etc.):


Toggle Between u Chart and u' Chart:

  • Specifically offered in the u Chart macro, you can toggle between a u Chart and a u' Chart by inputting either "False" (u Chart) or "True" (u' Chart):


Learn More...

Why Choose QI Macros Over Other Control Chart Software?



  • Only $299 USD - less with quantity discounts
  • No annual subscription 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

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free