QI Macros Control Chart Wizard

Take the Guesswork out of Selecting the Right Control Chart

Confused About Which Control Chart to Use?

With QI Macros You'll Never Struggle with Choosing the Right Control Chart Again

Based on calls from our tech support line, we can tell you that most folks struggle with which control chart to choose. Even if they have gone to training, 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.

QI Macros Can Help!

  • QI Macros Control Chart Wizard will analyze your data and select the right control chart for you.
  • It saves you time and mistake proofs the control chart selection process.
  • Spend your time on more important things like analyzing the control chart after its drawn.

No More Decision Trees

Rather than navigating 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 QI Macros, it is!

Use This

control chart wizard menu

Not This

minitab decision tree

QI Macros does what a tool is supposed to do; make the task easier and deliver results when you need them. Thanks for supporting our efforts in process control, continuous improvement and building a culture of Quality.

- Roger Savage
Quality Assurance Manager Molson Coors

To use QI Macros Control Chart Wizard

  1. Just select your data:

     control chart data example
  2. Then select the Control Chart Wizard from the QI Macros menu:

    wizard on qimacros menu

  3. The Control Chart Wizard will analyze your data and select the right control chart for you:
  4. control chart example

If it's trying to choose between a p chart and a u chart, it will ask this question:

p or u chart prompt

Answer "yes" for a u chart and "no" for a p chart.

How does QI Macros Control Chart Wizard select the right control chart?

# of Data Columns
Data Type
Sample size
>1 defect per sample?
Control Chart Selected
Data Example
1 Integers (attribute)     c Chart c chart data
1 Decimals (variable)    

XmR Chart

xmr chart data
2 Integers (attribute) constant  

np Chart

np chart data
2 Integers (attribute) varying No

p Chart

u chart data
2 Integers (attribute) varying Yes

u Chart

u chart data
2-5 Decimals or integers     XbarR Chart x bar r data
6+ Decimals or integers     XbarS Chart xbars data

We just completed our JCAHO review and received a 98 with NO time 1's so we are very excited and fired up about that. Our ability to use the control charts and talk with staff about them really helped! 

- Leana Hilde RN
Methodist Medical Center

Learn More...

Why Choose QI Macros Over Other Control Chart Software?



  • Only $299 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free