Show Process Change on Control Charts

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

It's easy to show process changes on a control chart created by the QI Macros.

• New and Existing Charts Created with a Macro
• Charts Created Using Control Chart Templates
• Excel 2007 Workaround for Showing Process Change on Imbedded Charts

Control Chart Templates - Watch Video

1. Look for the box to the right of the control chart marked Process Change at Row.



2. Input the row in the Excel spreadsheet where the process change occurred.



3. The template will calculate a new set of control limits starting at the data point in the row you entered. On the X chart templates the process change will be reflected on both the X and R charts.
4. Don't forget to rerun stability analysis using the new control limits. Click on the chart sheet. Use the QI Macros pull down menu to select "Analyze Stability."Note: This step needs to be performed separately for the X and R charts.

   

QI Macros Control Chart Menu Features

• Add Data to Control Charts
• Remove (Ghost) Point from Control Chart Calculations
• Delete Point from Control Chart
• Add Text to Data Point
• Show Process Change on Control Chart
• Analyze Stability with Control Chart Rules

Add Target or Goal Line to Chart

Other QI Macros and Control Chart Articles

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

If you love the QI Macros...
Please ask a handful of friends to download the trial version. Here's what to say:
Need easy to learn, easy to use software for Lean Six Sigma and SPC that works right in Microsoft Excel? Test drive the QI Macros!
Find out more at www.qimacros.com/excel-spc-software.html.
Get a 30-day trial at www.qimacros.com/free-spc-software.html.

Going to a meeting of quality professionals?
We can send you as many QI Macros 30-day trial CDs as you need. Just send an email with the address and quantities needed to orders@qimacros.com.

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!