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 help people think!

Copyright © 2008

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)?

Here is an example of a 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 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.

• Watch video creating a control chart in Excel using the QI Macros
• Use of a control chart - how do I interpret the results?
• Types of control charts
• How do I choose the right chart?
  With a control chart decision tree!
• Control chart examples

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

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

Download
FREE
30-Day Trial

Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee