How to Create a Pareto in Excel
Create a Pareto chart using Microsoft Excel
Create a histogram of data
Sort from largest to smallest
Calculate the percentages for each histogram data
Add the cumulative percentages
Create a bar chart of the historical data and a line chart for the cumulative percentages (as the secondary axis)
For more details, please watch the video. We hope this is helpful.