Pareto Chart Comparison in Excel using QI Macros

A pareto chart shows where effort can be focused for maximum benefit. To create two or more pareto charts using the QI Macros, select one column of labels and two or more columns of data (e.g., A2:C14 below to compare Line 1 and Line 2):

Click on the QI Macros Menu - Pareto Chart to draw both charts:

Comparing Pareto Charts

If the data for Line 1 before and after improvement looked like this:

The resulting pareto charts would show that Folded Flaps (the first "big bar") had been significantly reduced (from 105 to 6) and may have reduced other defects as well:

Now the team can turn it's attention to "Bent/Damaged Flaps" and "Carton will not open".

• Watch Video of Creating a Pareto Chart using the QI Macros
• Pareto Principle
• Pareto Analysis
• Pareto Chart Mistakes
• How to Compare Pareto Charts
• Pareto Chart Template for Excel
• Pareto Chart Examples for Excel

To learn more about how to analyze Excel tables using the Pareto chart, click here.

The Pareto Chart is just one of the tools included in the QI Macros for Excel SPC Software for Excel.

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