Process and Quality 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 © 2009

What is a Process or Quality 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 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.

• 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
• 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

Try QI Macros
FREE
For 30-Days

Or Buy It Now!

Unconditional
90-Day
Money-Back
Guarantee