Levey Jennings Control Chart in Excel

Create a Levey Jennings Chart in Seconds using QI Macros add-in

Healthcare labs use the Levey Jennings Charts to monitor key measures of health like cholesterol and glucose. The Levey Jennings Chart, unlike other control charts, use standard deviation or 10-20-30 percent for control limits.

QI Macros installs on Excel's menu. To create a Levey Jennings chart:

  1. Select your data.
  2. Select Levey Jennings on QI Macros menu.
  3. QI Macros does the math and draws the graph for you!

Examples of Levey Jennings Charts Created by QI Macros

Control Limits Based on Standard Deviation

levey jennings standard deviation chart

Control Limits based on Percent

levey jennings percentage chart

Here are the steps to create a Levey Jennings Chart using QI Macros:

  1. Click and drag over your data to select it.
  2. Next, click on the QI Macros menu > Control Charts (SPC) > Special (CUSUM, EWMA) and then on the type of Levey Jennings Chart you want.

    control chart menu
  3. QI Macros will perform all of the calculations, draw the chart and turn any unstable points or conditions red.

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 option is available in the Levey Jennings 10% Macro and Levey Jennings Fill in the Blanks template.

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