This Excel Pareto Chart for IT Operations has a single tab to input the data and separate tab for the chart, which updates automatically based on the data entered.
Pareto charts contain a bar graph with a line where individual values are represented by the bars, and the cumulative total is represented by the line. The left Y axis is the frequency each instance occurs or another unit of measure. The right Y axis is the cumulative percentage of the total number of occurrences or another unit of measure. The values are always displayed in descending order.
Pareto charts are used to indicate the most important item among a large set of factors. This is sometimes referred to as the “80/20 Rule”. In the 80/20 Rule, 80% of the occurrences are caused by 20% of the possible factors.