Add Data to 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 is easy to add data to control charts created using the QI Macros SPC Software.

The process is different depending on how you create your control chart:

• Control Charts Created with a Macro
• Control Charts Created Using Control Chart Templates

Control Charts Created with a Macro - Watch Video

When you run a macro you end up with 3 spreadsheets: your original datasheet, the chart and an intermediate spreadsheet where all of the calculations are performed. To add data to an existing chart:

1. Click on the intermediate data sheet (e.g., pdata1) and add the new data and labels in the rows under your old data.

   

2. If necessary, use Edit/Copy and Edit/Paste to copy any formulas down to the new rows.
3. Click on the chart sheet. Then click on the QI Macros pull down menu and select "Add Data to Control Charts"

   

   This menu is sometimes hard to find in Excel 2007s ribbon. To access the menu, click on the chart then on QI Macros Chart under Chart Tools.

   

4. Input the number of rows of data you just added to the intermediate spreadsheet and click OK. This function will change the "source data range" of the chart and will update the chart to display your new data.

   

5. Next rerun stability analysis on the chart. Click on the chart sheet. Use the QI Macros pull down menu to select "Analyze Stability". The QI Macros will rerun stability analysis on your old and new data.

   

Add Data to Control Charts Created with a Template - Watch Video

Control Chart templates are set up to take 50 data points. To add data to a template:

1. Make sure the menu in cell B1 is set to ALL so that all input rows are visible.

   

2. Simply input data into the next blank row.
3. Once you have used all 50 rows, you will need to expand the template to take more rows.
   • First use Edit/Copy and Edit/Paste to copy the formulas down into the new rows.

   

   • Next select the chart and select "Add Data to Control Charts" on the QI Macros pull down menu. Input the number of rows you just added.
4. Re-run stability analysis whenever you have added new data by clicking on the chart and then clicking on the QI Macros pull down menu. Select "Analyze Stability" to run stability analysis on your data. Any unstable point or condition will turn red.

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!