Need a Levey Jennings Template in Excel?
QI Macros has a Ready-Made Levey Jennings Template in Excel!
Go Deeper: Healthcare labs use the Levey Jennings charts to monitor key measures of health like cholesterol and glucose.
Example of a QI Macros Levey Jennings Control Chart Template in Excel
The template opens to the standard Levey Jennings chart. However, there are several other template options including percent, target and fixed standard deviation charts:
Here is how each Levey Jennings Control Chart Template works
| Chart | Center Line | Sigma Lines | Input Area |
| Levey Jennings 1-Chg | Calculated from the data | Calculated from the data and drawn at 1, 2 and 3 standard deviations |
 |
| Levey Jennings Percent | Calculated from the data | Default draws sigma lines at 10, 20, and 30% from the center line. Percentages can be changed using the drop down menu. |
 |
| Levey Jennings Target | Calculated from the data but can be overridden by inputting a different value in the Target cell |
Default draws sigma lines at 5, 10 and 15% from the center line. Percentages can be changed using the drop down menu. |
 |
| Levey Jennings Fixed Stdev | Calculated from the data but can be overridden by inputting a different value in the Center Line cell |
Calculated from the data but can be overridden by inputting a different value in the Stdev cell |
 |
Note: 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 Percent template and the Percent Macro.
Levey Jennings Templates in QI Macros for Excel:
Find the Levey Jennings templates by clicking on the QI Macros menu > Control Chart Templates > Special (CUSUM, EWMA) > Levey Jennings Stdev or Levey Jennings 10%:
Haven't you waited long enough?
Start creating your Levey Jennings Charts in just minutes.
Download a free 30-day trial. Get the Levey Jennings Charts now!
The Levey Jennings Charts is one of many tools included in QI Macros add-in for Excel.
QI Macros adds a new tab to Excel's menu, making it easy to find any tool you need. If you can't locate a tool, use the find tools feature on the far right side of QI Macros menu.
Learn More...
Why Choose QI Macros Over Other Control Chart Software?
Fast and Easy to Use
- Works right in Excel
- Create charts in seconds
- Easy to customize & share charts
- Free Training Anytime
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free
Affordable
- Only $349 USD
Quantity Discounts Available - No annual subscription fees
- Free technical support
