Control Charts in Excel

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

What is a Control Chart?

Statistical process control charts are line graphs that show how a process performs over time. Is it predictable or "out of control"? How much variation is there? Are there any special causes of variation (e.g., the point above the upper control limit shown below)?

What's Cool About Creating Control Charts in the QI Macros?

Just select your data and select the correct Control Chart from the QI Macros menu. Or select the Control Chart Wizard if you aren't sure which control chart to choose.

The macro will create a control chart and turn any unstable points or conditions red. Once you run a control chart there are lots of options such as: show process change, add data, add text notes, etc.

Here is an example of a quality control chart created using the QI Macros Software for Excel. Unstable points and trends in this control chart are highlighted in red:

Control Chart Control Limit Lines

The average and sigma lines (1, 2, and 3 sigma) of a process or quality control chart are calculated from the data. The Upper Control Limit (UCL) is the + 3 sigma line and the Lower Control Limit (LCL) is the - 3 sigma line. 99.7% of all data points will fall between these two limits.

• Use of a control chart - how do I interpret the results?
• Types of control charts
• Control chart examples
• List of control charts and other spc charts you can create using the QI Macros for Excel.

All of the variable and attribute control charts with stability analysis are included in the QI Macros SPC Software for Excel.

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

The QI Macros Control Chart Wizard will automatically choose the right control chart for you.

Download
QI Macros
30-Day Trial Now!