Compare Pareto Charts to Show Results

Before and After Pareto Charts Can Demonstrate the Success of Your Improvement Efforts

I really like the QI Macros. The Pareto chart is worth the purchase price of the whole deal.

Mike Dean, Ellwood Texas Forge

QI Macros Allow You to Create Multiple Pareto Charts at Once

1. 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., E2:G14 below to compare Line 1 and Line 2):
2. Click on the QI Macros Menu then Pareto Chart to draw both charts:

QI Macros will create a Pareto chart for each column of data you selected.

Before and After Pareto Charts Demonstrate Improvements

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".

Learn More...

• Watch Video of Creating a Pareto Chart using the QI Macros
• Summarize Data with a PivotTable and Create a Pareto with One Click
• Pareto Chart Template for Excel