QI Macros Show / Hide Data Sheet

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Copyright © 2009

Creating Charts Using the QI Macros Pull Down Menu

When you select your data and create a chart using the QI Macros pull down menu:

• The sheet with your data is left alone
• The QI Macros creates a new data sheet where all of its calculations are performed
• The QI Macros creates a new sheet to display the chart or two new sheets in the case of X and Range charts.

Hide Data Sheet Calculations

Some customers want to hide the data sheet where all of the calculations are performed when they have lots of charts in one workbook or they are sending their Excel workbook to leadership or another department. You can hide the data sheets as follows.

QI Macros 2009 and earlier versions - select the data sheets you want to hide and then click format / hide / sheet. Hold down the ctrl key to select more than one sheet at a time.

QI Macros 2010 and later versions - set your QI Macros to always hide or show the data sheets. The default is to show the data sheets but if you want to automatically hide them evey time you run a chart:

In Excel 2003 and earlier versions of Excel

1. Click on the QI Macros pull down menu and select Data Transformation tools
2. Under Data Transformation Tools select "Show / Hide Data Sheets"

In Excel 2007-2010: Click on the QI Macros Help menu and select "Show / Hide Data Sheets"

QI Macros Data Transformation Tools

• Box Cox Transformation
• Stack and Restack
• Get Sample From Table
• Paste Link and Paste Link Transpose
• PivotTable Wizard - Cross Tab
• Count Words in Selection
• Change Default Language
• Quick Keys On and Off
• Show / Hide Data Sheets

Other QI Macros and Control Chart Articles

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

Try QI Macros
FREE
For 30-Days

Or Buy It Now!

Unconditional
90-Day
Money-Back
Guarantee