Pareto charts highlight the biggest factors in a set of data. Following the idea of 80/20 analysis, they try to show which (approximately) 20% of the categories contribute 80% of the data being measured. They are often used in process improvement to show which factors deserve the most attention.


Quickly highlights most important data Excel automatically builds histogram and adds Pareto line


Less common chart type may be difficult to ready for many people Built-in Pareto Chart is not as easy to customize as a standard combo chart


Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Pareto chart - 54Pareto chart - 71Pareto chart - 7Pareto chart - 58Pareto chart - 96