What Do I Do With My Data?

First: Is Your Data In Horizontal Rows?

data organized in columns

  1. To get it in position for QI Macros, copy the data.
  2. Switch to another spreadsheet or a blank area in your existing sheet and use Paste Special (Transpose) to transpose the data from 3 rows to 3 columns:

    paste special transpose

    Vertical Excel Data

Now: Your Data Is In Vertical Columns

If you have time series data (data over time):

1. Click & drag over the data to select it:

Vertical Excel Data

2. Next click on QI Macros Menu and select the Chart Wizard (top right):

chart wizard runs all possible charts


3. The Chart Wizard will produce every chart that matches your data:


np chart
Learn more about the charts you can create using QI Macros.

If you have two sets of data for comparison

1. Click & drag over the data to select it:

f test data


2. Click on the QI Macros Menu and run the Stat Wizard:

stat wizard selects possible statistical tests


3. The Stat Wizard will conduct every statistical analysis test available for your data:

f test results

Learn more about the statistical tests you can perform using QI Macros.

If Your Data has Text and Numbers

1. Click on two headings:

Excel table of data

2. Click on the QI Macros Menu and run the Improvement Project Wizard (formerly Data Mining Wizard):

Improvement Project Wizard

3. The Improvement Project Wizard turn your data into an entire improvement project:

data mining wizard output

Learn more about the data mining and analysis you can perform using QI Macros.

Why wait? Start creating these charts and diagrams in seconds using
QI Macros add-in for Excel.