What is a Pareto Chart in Excel?

A Pareto chart helps you pinpoint the biggest sources of a problem so you can focus your energy where it matters most. Based on the 80/20 rule, it's a powerful way to see the "vital few" from the "trivial many." This tutorial will walk you through exactly what a Pareto chart is, why it's useful, and how to create one step-by-step in Microsoft Excel.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly is a Pareto Chart?

The Pareto chart is named after Vilfredo Pareto, an economist who noticed that about 80% of the land in Italy was owned by 20% of the population. This concept, known as the Pareto Principle or the 80/20 rule, pops up everywhere:

• 80% of your company's sales might come from 20% of your customers.
• 80% of software crashes might be caused by 20% of the reported bugs.
• 80% of customer complaints might stem from 20% of the possible issues.

A Pareto chart is a special type of chart that visualizes this principle. It's a combination of a descending bar chart and a cumulative percentage line graph, all in one. Here’s what it shows:

• The Bars: Each bar represents a specific category or cause (like "Wrong Item Shipped" or "Damaged Product"). The bars are arranged in descending order, so the tallest bar on the left is your biggest problem, and they get progressively smaller to the right.
• The Line: The curved line hovering over the bars shows the cumulative percentage of the total. As you move from left to right, the line climbs, showing you the running total of a few issues making up the bulk of the problem.

By looking at the chart, you can instantly see which problems contribute most to the total. The point where the cumulative percentage line hits 80% marks the "vital few" categories you should prioritize.

Why Is a Pareto Chart So Useful?

Pareto analysis isn't just an interesting statistical quirk, it's a practical tool for smarter decision-making. By creating a Pareto chart, you can improve problem-solving, boost efficiency, and communicate more effectively.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

It Forces Prioritization

It's easy to feel like you have a hundred different problems to solve at once. A Pareto chart cuts through the noise. It visually separates the most significant drivers of an issue from the less impactful ones. Instead of trying to fix everything, you can laser-focus on the top 2-3 issues that will resolve 80% of the pain. For a resource-strapped team, this is a game-changer.

Example: An e-commerce store manager analyzes customer returns. The Pareto chart reveals that "Wrong Size Ordered" and "Item Not as Described" account for 75% of all returns. Instead of overhauling the entire return process, they can focus an initiative on improving size guides and product photos first.

It Reveals a Clear Path to Improvement

The chart doesn't just show problems, it shows opportunity. Focusing on the tallest bars gives you the highest return on your improvement efforts. Resolving one or two major issues can create a much bigger impact than fixing ten minor ones. This helps in demonstrating progress and securing buy-in for future projects.

Example: A software product manager examines user-reported bugs. The Pareto chart shows that the top three bugs – related to page load speed and a broken checkout button – are responsible for 80% of all support tickets. The development team can justify pushing back other features to fix these crucial, high-impact bugs immediately.

It Simplifies Complex Data

Presenting a huge spreadsheet of complaint data in a meeting can make eyes glaze over. A Pareto chart tells a powerful story in a single image. It's an intuitive and persuasive way to communicate findings to your team, managers, or stakeholders. They don't need to be data analysts to understand where the biggest problem lies.

Example: A marketing team lead analyzes reasons for email unsubscribes. The chart clearly shows "Too Many Emails" is the leading cause. They can present this single chart to leadership to get approval to test a lower sending frequency, a much more direct approach than showing raw unsubscribe data.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

How to Make a Pareto Chart in Excel: Step-by-Step Guide

Excel doesn’t have a one-click "Pareto chart" button in older versions (though newer versions do have it in the "Statistical" chart types). However, building one from scratch is easy and gives you full control over the formatting. Let’s walk through the process using an example of customer service complaints.

Step 1: Set Up & Sort Your Data

First, you need a simple table with your data. Create two columns:

• Your categories (e.g., Complaint Type).
• The frequency or count for each category (e.g., Number of Complaints).

Critically, you must sort the data by the frequency count in descending order. To do this, highlight your data, go to the Data tab, and click Sort. Choose to sort by the "Number of Complaints" column, from "Largest to Smallest."

Step 2: Calculate the Cumulative Percentage

Now, we need to add a third column to calculate the running total as a percentage. Title this column "Cumulative %".

This sounds tricky, but it’s a simple formula. In the first cell of your new column (C2 in our example), the formula references the first count and divides it by the total count:

=B2/SUM($B$2:$B$8)

Note the dollar signs ($) in the SUM formula. This creates an absolute reference, so when you drag the formula down, the total range doesn't change.

For the second cell (C3), you’ll add your previous cumulative value to the current row’s percentage of the total:

=C2+(B3/SUM($B$2:$B$8))

Now, just click the small square in the bottom-right corner of cell C3 and drag the formula down to the rest of the column. Go to the Home tab and format the column as a Percentage.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 3: Insert a Combo Chart

Now for the fun part. Highlight all three columns of data, including the headers.

Go to the Insert tab on the Ribbon, click on the icon for Insert Combo Chart, and select Clustered Column - Line on Secondary Axis.

Alternatively, click "Recommended Charts," go to the "All Charts" tab, and select "Combo" at the bottom of the list. Here, you get more control:

• For the "Number of Complaints" series, set the chart type to Clustered Column.
• For the "Cumulative %" series, set the chart type to Line and — this is the most important part — check the box for "Secondary Axis".

Excel will instantly generate a chart that is almost a Perfect Pareto chart.

Step 4: Format the Secondary Axis

Your chart looks good, but you'll notice one problem: the secondary (right) axis for the percentage line goes up to 120% or more by default. We want it to max out at 100%.

To fix this:

1. Right-click on the numbers of the secondary axis (the percentages on the right side of the chart).
2. Select Format Axis... from the dropdown menu.
3. In the Format Axis pane that appears on the right, find the "Bounds" section.
4. Change the Maximum bound from whatever it is to 1.0 (Excel sees percentages as decimals, so 1.0 = 100%).

Step 5: Final Touches and Formatting

Your Pareto chart is functional, but a few tidying-up touches make a huge difference for readability:

• Chart Title: Give it a clearer, more actionable title like "Reasons for Customer Complaints - January 2024" instead of just "Chart."
• Axis Titles: Add axis titles to label each one. Click the '+' icon next to the chart > "Axis Titles". You might label the left axis "Number of Complaints" and the right axis "Cumulative %".
• Legend: Make sure your legend is clear, or you can remove it if your titles are explicit enough.

Common Pitfalls to Avoid

Creating a Pareto chart is straightforward, but a few common mistakes can throw off your analysis:

• Sorting the Data Incorrectly: The entire logic of a Pareto chart rests on seeing the biggest issues first. If you forget to sort your data in descending order, your chart will just be a regular bar chart and won't tell you anything significant.
• Incorrect Cumulative Percentage Formula: Using relative references instead of absolute ones in the SUM part of your cumulative percentage formula will cause calculation errors as it drags down the column. Look for those $ signs!
• Missing Secondary Axis: Placing your cumulative percentage line on the primary axis will make it look flat and won't accurately portray reality. Always check the "Secondary Axis" box for the percentage series.
• Over-interpreting the 80/20 Rule: The 80/20 principle is a guideline, not a law. Sometimes you might find a 70/10 rule, a 90/10 rule, or something else altogether. A Pareto chart is not meant to rigidly fit your data, but to find out the most impactful areas.

Final Thoughts

There you have it! A Pareto chart is far more than just a fancy graphic, it's a powerful tool for prioritization and decision-making. By running a step-by-step process in Excel, you can confidently turn data analysis into actionable insights that drive improvement.

As you start to set up your next Excel Pareto chart, you might find that the process is manually time-consuming, especially when you're pulling data from different sources like Shopify. That's where we step in. Instead of manually updating hundreds of inputs, our Graphed tool automatically connects your data sources like Shopify sales campaigns for the last quarter. Our automation and dashboards help you stay on top of your data analytics with the ease of drag-and-drop tools.