QI Macros Trial #2 - Creating Charts


© 2007 KnowWare International, Inc. DBA LifeStar
2253 S. Oneida St., Ste 3D
Denver, CO 80224

Jay Arthur
888-468-1537
303-756-9144
Email Us

We help people think!

Now Let's Look at How to Draw Control Charts, Histograms and Pareto Charts with The QI Macros.

To Draw a Chart:

Just 1) select your data and 2) choose a chart from the pulldown menu 3) the macro will prompt you for chart and axis titles. When the macro is complete it creates two new worksheets: one for the chart and one where all of the calculations are performed. Watch Video.


To Draw Control Charts

For control charts, try the control chart wizard which will analyze your data and choose the best chart automatically.

Test Data

If you don't have any data or don't know how to organize your data to run a chart, no problem. We've installed sample data for all of the charts on your machine in c:\qimacro\testdata.

To Open a Chart Template:

The QI Macros have fill-in-the-blank-templates for most charts.

  1. Choose "Fill-in-the-Blanks Templates" from the QI Macros pulldown menu, then SPC charts, select from any of the charts listed (e.g., SPC-c Chart) Watch Video.
  2. Just type or paste data into the chart template.

QI Macros Help

Near the bottom of the QI Macros pulldown menu you'll find the help file. In it you'll find further descriptions of each of the tools and templates. Watch Video.

In the following lessons, we'll take a more detailed look at each of the main features of the QI Macros.

After you've tested the QI Macros enough to satisfy your curiosity about how well the software can meet your needs, you can purchase online at https://www.qimacros.com/order230.html 24 hours a day.

If you have questions, email them plus your sample data to: lifestar@rmi.net

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

Thank you again for your interest in the QI Macros. View Next Lesson

Buy QI Macros Excel SPC Software for Histograms and Control Charts Now QI Macros Excel SPC Software for Histograms and Control Charts $139 Plus S&H


© 2007 KnowWare International Inc. (888) 468-1537
knowwareman@qimacros.com
Home | Lean Six Sigma | QI Macros | KnowWare | Site Map

QI Macros 30-day Trial & FREE QI Macros Course
Name:
E-mail
 

QI Macros SPC Software for Excel
Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee

The QI Macros for Excel $139, is an inexpensive easy to use set of Excel add-ins for statistical process control and Lean Six Sigma. It draws line, pie, bar, pareto, box whisker, histogram (Cp, Cpk), scatter and control charts (with stability analysis).

It contains over 70 fill in the blank templates such as the Ishikawa diagram, QFD, DOE, FMEA, PPAP, and Gage R&R for MSA. Performs ANOVA, t-test, F-test, and regression analysis.

Buy All-in-One, Excel SPC Software Now

Quantity Discounts

Customer Testimonials

Minitab Comparison

QI Macros FAQs

FREE Lean Six Sigma Course
& QI Macros 30-day Trial
Name:
E-mail