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 Charts Created with a Macro
• Existing Charts Created with a Macro
• Control Chart Templates
• Excel 2007 Workaround for Showing Process Change on Imbedded Charts

New Charts Created with a Macro

To calculate two or more sets of control limits on new charts simply leave a blank row between the data points where you want the limits to change.

Select the data including the blank row(s) and run the chart. You should get a chart with two or more sets of control limits.

Existing Charts Created with a Macro - Watch Video

1. Go to the chart and click on the first data point where the process change occurred. Note: The first time you click on the point, Excel will select the whole line. Click on the point a second time to get just the point. If you have done this correctly, Excel will highlight your point and the point before it.

   

2. Click on the QI Macros pull down menu and select Show Process Change on Control Chart.

   

3. The macros will calculate a new set of control limits starting at the data point you selected. The macros will also update the UCL, Average and LCL labels to reflect the separate set of control limits. Note: you can do this more than once on a chart. The example below shows three separate sets of control limits.

   

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 With Control Chart Rules." The QI Macros will rerun stability analysis using the new control limits.

5. Note: Performing these steps on an X chart will not update the R chart. You will need to update the R chart separately.

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.

Try QI Macros
FREE
For 30-Days

Or Buy It Now!