How to Compare Pareto Charts

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

Copyright © 2011

Comparing Pareto Charts

Process improvement and Six Sigma require proof that an improvement actually changed performance. If part of the analysis involved a pareto chart or two, the verification of root causes and improvements should also contain a pareto chart.

Essentially, the improvement story should reflect before and after paretos:

Simply hang onto the original pareto chart for comparison. After root cause analysis and implementation, redraw the pareto chart using the new performance data. The "big bar" on the pareto chart should have moved further right (i.e., gotten smaller or been eliminated all together). There should be a new "big bar."

In the QI Macros, if you copy and paste the old and the new pareto charts onto a single sheet, you can compress the scale of the second chart to show the change and change the color of the bars.

• Compare Multiple Pareto Charts in Excel using QI Macros
• Pareto Charts in Excel
• Watch Video of Creating a Pareto Chart using the QI Macros
• Pareto Principle
• Pareto Analysis
• Pareto Chart Mistakes
• 80/20 Rule and the Pareto Principle
• Pareto Chart Template for Excel
• Pareto Chart Examples for Excel

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

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!