How to Create a Pareto Chart in Excel?

Enter your data in two columns: categories and values

Sort the values from largest to smallest

Select the data range

Go to the Insert tab

Click Insert Statistic Chart

Choose Pareto

Add or edit the chart title if needed

Format the axes if needed

Add data labels if needed

Save the workbook

Suggested for You

Trending Today