How to create Pareto Charts in Excel?

Pareto chart, also called a Pareto diagram, is a graph based on the Pareto principle. In Microsoft Excel, it is kind of sorted histogram that contains both vertical bars and a horizontal line.

A Pareto Chart is a graph that indicates the frequency of defects, as well as their cumulative impact. Pareto Charts are useful to find the defects to prioritize in order to observe the greatest overall improvement.

  1. Select your table.
  2. On the Insert tab, in the Charts group, click Recommended Charts.
  3. Switch to the All Charts tab, select Histogram in the left pane, and click on the Pareto thumbnail.
  4. Click OK.