Want Laney u' Chart | u Prime Charts in Excel?

QI Macros can create them for you!

Create an u' Chart by running QI Macros:

  1. Select your data.
  2. Click on QI Macros menu > Control Charts (SPC) > Attribute> u' .
  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.

Go Deeper: The purpose of a u Chart is to determine stability of "counted" data (e.g., errors per bill, dents in a car door, etc.) when there can be more than one defect per unit and the sample size varies.

The u chart works for most data sets. However, if your data meets certain criteria you may need to consider an XmR Chart or a Laney u' Chart (u Prime).

Consider an XmR Chart if the denominator does not vary widely from sample to sample and your u chart looks like the one below where the control limits seem too narrow for the data and most points are highlighted as unstable.

compare u chart to laney u chart

Here is an XmR Individuals Chart run on the same data:

xmr chart compare to laney u chart

Consider a Laney u' Chart (u Prime) if: the sample sizes in your denominator vary greatly.

A Laney u' Chart (u Prime) will have wider control limits than the u Chart and it will have varying control limits that may help identify unstable points not identified by the XmR Chart. Here is a Laney u' Chart of the same data.

laney u chart

QI Macros add-in for Excel contains a Laney u' Chart template. Click on QI Macros > Control Chart Templates > Attribute (c,np,p,u,g,t) > u Chart to open up the u Chart template. Then click on the U' Chart Skyline tab at the bottom to open up the Laney u' Chart (u Prime) template.


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). This option is located to the right of your chart:


Stop Struggling with u' Charts!
Start creating your u' Charts in just minutes.

Download a free 30-day trial. Get u' Charts now!

Learn More...

Why Choose QI Macros Over Other Control Chart Software?

easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

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



  • Only $349 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support