Show - Don't Show 1 and 2 Sigma Lines

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

QI Macros control charts utilize these control limits calculated from your data to evaluate process stability:

• + 3 sigma line also known as the upper control limit (UCL)
• + 2 sigma line
• +1 sigma line
• a center line (CL)
• - 1 sigma line
• - 2 sigma line
• - 3 sigma line also known as the lower control limit (LCL)

Here is what the control limit and sigma lines look like on a control chart.

Some industries like healthcare, prefer not to view the sigma lines. They just want a chart with the UCL, LCL and CL.

The QI Macros give you two ways to turn off and on the 1-2 sigma lines:

Option 1

1. Click on the QI Macros menu item, Control Charts and then Control Chart Rules.
2. Select Show Don't Show 1-2 Sigma lines.



3. Now run a chart. The 1 and 2 sigma lines should be gone.
4. To turn the lines back on, simply click on the QI Macros, Control Charts, Control Chart Rules and re-select Show Don't Show 1-2 Sigma lines.

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

Option 2

After you have run a chart, click on the QI Macros chart menu

Then click on Show/Hide 1-2 Sigma Lines. The QI Macros will update the chart and all charts you run after that.

QI Macros Control Chart Features and Articles

• Add Target or Goal Lines to Control Charts
• Change Control Chart Stability Rules
• Choosing the Right Control Chart
• Control Chart Dashboards
• Control Chart Limit Calculations
• Control Chart Rules Menu
• p chart and u chart format options
• Show/Don't Show 1 & 2 Sigma Lines

Other QI Macros and Control Chart Articles

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!