Choosing the Right Chart | Chart Wizard Selects the Right Chart

Chart Wizard in QI Macros for Excel
home · products · services · search · view cart · contact

NAVIGATION

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

Confused About Which Chart to Choose?

Still Can't Figure It Out Even After Attending a Class or
Trying to Use a Decision Tree like the Ones in Minitab?

You Are Not Alone!

Training isn't enough! Based on calls from our tech support line, we can tell you that most folks struggle with which chart to choose. Even if they have gone to a training class, it doesn't matter, they still spend time they don't have trying to decide on the right chart and then they still aren't sure.

Decision Trees are Cumbersome. Rather than having to think your way through the forest of decision trees like the ones in Minitab, wouldn't it be great if the decision tree was already coded into the software? In the QI Macros, it is!

Minitab A Forest of Decision Trees	QI Macros Turns Decision Trees into a One Click Chart Wizard

The QI Macros Chart Wizard will analyze your data and choose the right charts for you. It saves you time and mistake proofs the Chart selection process. Spend your time on more important things like analyzing the charts after they are drawn.

To use the QI Macros Chart Wizard:

Just select your data
Then select the Chart Wizard from the QI Macros menu.
The chart wizard will draw one or many charts based on your data.

Excel 2007-2010

Excel 2000-2003

Example:

1. Select Your Data - XbarR Chart

2. Click on Chart Wizard and the Chart Wizard will draw all of the charts

Descriptive Statistics:
Histogram, Box Plot, Confidence Intervals, Normal Probability Plot

Dot Plot

Box and Whisker Plots

XbarR Chart

Here's how the Chart Wizard selects the chart:

Columns of Data	1	2	10+
Integers or Decimals	If Max> 10*Min and Rowheadings not dates Pareto Chart
Integers	c Chart	if Numerator/ Denominator p and u Chart Scatter if Denominator is constant np Chart
Integers or Decimal	Descriptive Statistics includes histogram, normal probability plot, boxplot and confidence intervals
		Box & Whisker by Row and Column
Normal	XmR Chart	XbarR Chart	XbarS Chart
Non-Normal	XmR Median Chart	XMedianR Chart	XbarS Chart

The QI Macros SPC Software for Excel:

Draws np, p, c, u, XmR, XbarR, XMedianR and XbarS control charts
Calculates and draws lines for: average, + 1 sigma, +2 sigma and +3 sigma (UCL and LCL)
Performs stability analysis and turns any unstable point or condition RED
Allows you to add data to existing control charts and create Charts with multiple (stair step) control limits

All of the variable and attribute control charts with stability analysis are included in the QI Macros SPC Software for Excel.

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

For more help, download our Choosing the Right Chart quick reference card.

For an explanation of why there are so many different types of control charts see our QI Macros formulas page.

Download
QI Macros
30-Day Trial Now!

Chart Wizard in QI Macros for Excel

Confused About Which Chart to Choose?

Still Can't Figure It Out Even After Attending a Class or Trying to Use a Decision Tree like the Ones in Minitab?

You Are Not Alone!

To use the QI Macros Chart Wizard:

Example:

Still Can't Figure It Out Even After Attending a Class or
Trying to Use a Decision Tree like the Ones in Minitab?