Control Limits Shown on QI Macros Control Charts

Show - Don't Show 1 and 2 Sigma Lines

QI Macros control charts calculate and use ALL control limits to evaluate process stability. However, you have options on which control limits you want to display.

Control Chart with only CL, UCL and LCL Visible

control chart ucl lcl

This is QI Macros default setting since
most users prefer not to view the sigma lines.

Control Chart with all Control Limits Visible

control chart with control limits

QI Macros offers the following option to turn on and off the 1-2 sigma lines:

After you have run a chart, click on the QI Macros Chart menu and select Show/Hide Sigma Lines. Within the drop-down menu, you will have 4 Show/Hide Sigma Lines options. QI Macros will update the chart and all charts you run after that:


Note: You only need to set your preference once. It will be retained even if you close Excel and/or restart your computer.

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 $329 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support