Chart Wizard in QI Macros for Excel
Automatically Chooses the Correct Charts for You
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 a 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 

Excel 2010, 2013, 2016, 2019 and Office 365 

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 click and drag over your data to select it.
 Then click on the Chart Wizard from the QI Macros menu:
 The Chart Wizard will draw all of the most probable charts and run descriptive statistics.
Descriptive Statistics:
Histogram, Box Plot, Confidence Intervals, Normal Probability Plot
Dot Plot
Box and Whisker Plots
XbarR Chart
Here's how the QI Macros Chart Wizard selects the chart:
Columns of Data 
1 
2 
39 
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 

NonNormal 
XmR Median Chart 
XMedianR Chart 
XbarS Chart 