QI Macros Lesson 2 - Tips for Creating 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

The QI Macros SPC Software for Excel has Five Parts and Numerous Wizards to Assist With Your Data Analysis:

1. Over 30 charts including histograms, pareto charts, scatter plots, box whisker plots and all variable and attribute control charts. Just select your data and then click on the QI Macros menu and select the chart you want to run. If you are not sure, select the Chart Wizard to run various charts on your data or the Control Chart Wizard to select the right control chart.
2. Over 90 Fill-in-the-blank templates and tools including fishbones, FMEA, DOE, Gage R&R, PPAP forms and more.
3. Statistical tools including Anova, f-test, t-test, regression, data normality test, sample size calculator and more. Select your data and click on the Statistics Wizard to run the most common statistical tests for your data.
4. Data Transformation Tools to help organize and analyze your data including stack and restack. Includes WordCount and PivotTable Wizards to help you summarize and organize your data.
5. Automated Control Chart Dashboards - just drop your data into these pre-formatted templates.

This lesson will cover charts created using macros from the pull down menu. Each of our remaining lessons will cover one of the other five parts.

To Create a Chart Using a Macro from the Pull Down Menu

Watch Video of this process

1. Just select the data to graph (using the mouse to click and drag).
2. Then, using the QI Macros pull down menu, select the chart you want to graph.
   
   
   
   
3. The QI Macros will prompt you for additional information including chart titles and names of the x and y axis and they will do the math and draw the graph for you.
   
   
   
   
4. After the macro has run, you will usually have three worksheets:

• Your original data sheet
• An intermediate sheet where all of the calculations are performed
• The sheet with the chart

Data Format and Selection Tips

Some of the most popular charts created with the QI Macros are:

Control Charts	Histograms with Cp and Cpk
Pareto Charts	Scatter Diagrams
Box Whisker Plots	Multivari Charts

More Information on Control Charts

Control Chart Wizard - If you don't know which control chart to select, choose the Control Chart Wizard. It will analyze your data and choose the right chart for you.

Excel 2003 and previous versions	Excel 2007-2010

Stability Analysis - The control chart macros will run stability analysis on your data and turn any unstable points or conditions red. See these links for more information:

• Stability Analysis Rules
• How to Change Control Chart Rules
• How to Show or Hide 1 and 2 sigma lines
• How control chart limits are calculated in the QI Macros

Control Chart Menu Features - After you run a control chart, the QI Macros menu on the chart worksheet changes to offer you additional functionality.

• 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

Other Control Chart Features

• Add Target or Goal Line to Chart
• p and u chart format options

Need extra help understanding when to use each chart and how to analyze the results? Consider one of the following:

• QI Macros Training CD - Step by step instructions for loading and using the QI Macros.
• QI Macros Tools Example Book - detailed explanations and examples of each chart
• SPC Simplfied Book - provides detailed explanations of control charts and histograms, the formulas and how to interpret the results.
• SPC Simplified 1 hour Training Video - Covers stability and capability analysis with a focus on the charts and what they tell you not the statistics involved.

In Lesson #3 we cover the fill in the blank templates in the QI Macros.

View previous lesson .................................................View next lesson

To sign up for this series tell your friends to send an email to qimacros@aweber.com

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!