Creating Charts with Data in Excel Tables

Excel 2007 and 2010 allow users to create formatted tables. Users sometimes ask if they can use Excel Tables with the QI Macros. The answer is absolutely:

To create a table, click on Insert-Table:

Then select your data and indicate if it has headers or not:

Excel will format the result:

You can the select this data and run charts or statistics just like regular data.

You can get into trouble, however, if you try to combine cells and tables with headers as in this example. This user tried to put headers on top of a table that had numeric cells defined as headers. The QI Macros remove the extra headers in row 2. Therefore the first line of data in row 2 was left out of the calculations.

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

	Macintosh	PC
QI Macros - One License Per Computer - Download Now and Get Backup CD & User Guide (#230) in 1-3 days - $199 + S&H
QI Macros - One License Per Computer - Download Only - No Shipping or Customs Duties (#W230) $199

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.