Tips for Creating Charts

QI Macros Lesson 2

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

  1. Over 30 Six Sigma tools and SPC 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 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 100 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 Mining and Analysis Tools to help organize and analyze your data including stack and restack. Includes WordCount and PivotTable Wizardsto 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 Tutorial Video of the Process

  1. Just select the data to graph (using the mouse to click and drag).
  2. Then, using QI Macros menu, select the chart you want to graph:
  3. 2010-ribbon-menu

    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:

    p control chart 
    After the macro has run, you will usually have three worksheets:

    1. Your original data sheet
    2. An intermediate sheet where all of the calculations are performed
    3. The sheet with the chart

Data Format and Selection Tips

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

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.

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:

Control Chart Menu Features - After you run a control chart, QI Macros chart menu offers you several options to update or change your chart.

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

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

« Previous Lesson | Next Lesson »

Purchase QI Macros SPC Software for Excel through our secure shopping cart or try a free, QI Macros 30-day trial!