Excel 2007 Workaround for Selecting Individual Points on Imbedded 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

Imbedded Charts in Excel 2007

Excel 2007 will not let you select an individual data point on an imbedded chart (a chart located on the same sheet as the data).

Imbedded Charts in the QI Macros and associated workarounds

The QI Macros contains or creates the following imbedded Charts: X Chart Macros, Control Chart Templates and Dashboards. If you select a point and then try to delete it, ghost it or show a process change using the chart menu you will receive one of these two error messages:

1. If you receive this message, go to the sheet with just the charts (i.e. X chart macro results) and select the point on the stand alone chart to complete the desired function.

2. If you receive this message, input the point in the box to complete the desired function (delete point, ghost point or show process change). For example, to ghost the fifth point in your data input a 5.

This issue does not occur in other versions of Exce. Hopefully it will be fixed in Excel 2007 Service Pak 3.

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!