Pareto Chart Examples in Excel created with QI Macros

A pareto chart shows where effort can be focused for maximum benefit. Pareto charts can be used in many ways to show:

• The most common type of defect
• The most common source of defects.
• The cost of an error

Pareto Chart Example of the Most Common Type of Defect

The most common pareto chart example involves the frequency of defects:

Pareto Chart Example of the Most Common Source of Defect

Another common pareto chart example involves the source of defects. In this case, Line 3:

Pareto Chart Example of the Cost of an Error

Another Pareto Chart example involves cost. Sometimes the most common type of defect isn't the most expensive. To reduce costs, consider focusing on reducing the most costly error.

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

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

The Pareto Chart for Excel and Pareto Chart Template are 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