# How To Draw Pareto In Excel

Productivity Software

Drawing a Pareto chart in Excel is a valuable skill for anyone involved in quality management or process improvement. Whether you’re a seasoned analyst or a beginner like myself, creating a Pareto chart can help identify the most significant factors contributing to a problem. In this article, I’ll guide you through the step-by-step process of drawing a Pareto chart in Excel and share some personal insights along the way.

## Setting Up the Data

The first step in creating a Pareto chart is to gather the relevant data. In my personal experience, it’s important to ensure that the data is accurate and comprehensive. Once you have the data, you can organize it in Excel with the categories in one column and their corresponding frequencies in another. For example, if you’re analyzing customer complaints, the categories could be different types of complaints (e.g., late delivery, product quality, customer service), and the frequencies would represent the number of occurrences for each type.

## Calculating Cumulative Percentages

After organizing the data, I’ve learned that it’s time to calculate the cumulative percentages. In Excel, I use a simple formula to do this. I create a new column for the cumulative percentage and use the following formula for the first cell: `=SUM(\$B\$2:B2)/SUM(\$B\$2:\$B\$10)` (assuming the data is in columns A and B from rows 2 to 10). Then, I fill down the formula for the rest of the cells in the cumulative percentage column.

## Creating the Pareto Chart

With the data and cumulative percentages in place, it’s time to create the Pareto chart. I select both the category labels and the cumulative percentage data, and then I insert a bar chart. I personally prefer to use a clustered column and line chart combination. This showcases the individual frequencies as columns and the cumulative percentage as a line, emphasizing the 80/20 rule that the Pareto chart represents.