Trying to Create Levey Jennings 10-20-30% Charts in Excel?

QI Macros can create them for you!

Create an Levey Jennings Percent Chart using QI Macros:

  1. Select your data.
  2. Click on QI Macros menu > Control Charts (SPC) > Special> Levey Jennings % .
  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: Uses 10% of the Average to Calculate Control Limits

Healthcare labs use the Levey Jennings Charts to monitor key measures of health like cholesterol and glucose. The Levey Jennings Chart, unlike other SPC charts, has an option to use 10 percent of the average as a way of calculating control limits:

levey jennings percent control chart in Excel

Once the chart is created, you can click on the data sheet created when the macro was run and change the percentage (in cell I1) to 5% or whatever you desire:

change percent in levey jennings percent chart

QI Macros will update the chart with new control limits. Note: Use the QI Macros chart menu to re-rerun stablility analysis with the new limits. You may also want to adjust the scale of the y-axis:

levey jennings change percent

According to SOFT / AAFS FORENSIC TOXICOLOGY LABORATORY GUIDELINES 9.1.12 standard deviation may represent an unacceptably large percentage deviation from the mean. Therefore, a realistic percentage deviation should be used, such as ±20% or ±30%. This was added to the QI Macros Levey Jennings Fill-in-the-Blanks template in July 2009 and QI Macros menu in December 2010.

Stop Struggling with LJ Percent Charts!
Start creating your LJ Percent Charts in just minutes.

Download a free 30-day trial. Get LJ Percent 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