How to Make a Pareto Chart in Tableau with AI

Ever find yourself looking at a long list of customer complaints, product defects, or reasons for missed deadlines and wondering where to even begin? When every problem seems urgent, the Pareto chart is the perfect tool for cutting through the noise. This simple chart helps you identify the "vital few" - the 20% of causes that are responsible for 80% of the problems - so you can focus your energy where it matters most.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

This tutorial will walk you through building a Pareto chart in Tableau step by step. You'll learn the traditional way and see how new AI-powered tools are making the entire process faster and more accessible for everyone on your team.

What Exactly is a Pareto Chart?

A Pareto chart is a special type of chart that contains both bars and a line graph. The bars represent individual values in descending order, while the line represents the cumulative total. It's based on the Pareto principle, also known as the 80/20 rule, which suggests that in many situations, roughly 80% of the effects come from 20% of the causes.

Why is this useful for business analysis?

• Pinpoints Critical Issues: It visually separates the most significant problems from the less impactful ones, showing you exactly where to focus your improvement efforts for the biggest returns.
• Improves Decision-Making: Instead of guessing what to tackle first, you get a clear, data-driven roadmap. Seeing that three out of fifteen complaint types make up 75% of all issues makes prioritizing much simpler.
• Tells a Clear Story: It’s an incredibly effective way to communicate problems and priorities with your team or stakeholders. The visual distinction between the "vital few" and the "trivial many" is immediate and easy to grasp.

For example, a marketing manager could use a Pareto chart to see which handful of ad campaigns are driving the vast majority of conversions. Similarly, an e-commerce store owner could use one to identify the specific products that account for 80% of all returns.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Before You Begin: Preparing Your Data

A Pareto chart requires two main components from your dataset:

1. Categories: This is the qualitative data you want to analyze, like "Reason for Return," "Customer Complaint Type," or "Campaign Name." This will be the dimension you use to create the different bars in your chart.
2. Measure: This is the quantitative data that reflects the impact or frequency of each category, like "Number of Returns," "Count of Complaints," or "Total Sales." This metric is what you'll measure and sort.

For this tutorial, let’s imagine we're an e-commerce company analyzing customer support tickets. Our data includes a column for Ticket Category (the categories) and a count for the Number of Tickets in each category (the measure).

How to Make a Pareto Chart in Tableau: Step-by-Step

Building a Pareto chart in Tableau gets into some of its more intermediate features - specifically, table calculations and dual-axis charts - but it's a great way to deepen your skills. Follow these steps carefully.

Step 1: Connect to Your Data Source

Open Tableau and connect to the data file (like an Excel sheet, CSV, or database) that contains your categories and measures. Once it's loaded, Tableau will display your data sources, and you can move to the worksheet.

Step 2: Create the Initial Bar Chart

First, we build the foundation of our chart - the bars.

• Drag the dimension you want to analyze (in our example, Ticket Category) to the Columns shelf.
• Drag the measure you want to count (Number of Tickets) to the Rows shelf.

(Your screen will immediately show a basic vertical bar chart, with one bar for each ticket category and the height corresponding to the number of tickets.)

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 3: Sort the Data

A key feature of a Pareto chart is that the bars are sorted in descending order. This arranges the categories from the highest frequency to the lowest.

• Hover over the axis for your measure (the vertical axis showing the Number of Tickets).
• A small sort icon will appear. Click it to sort the bars in descending order. Alternatively, you can right-click the Ticket Category pill in the Columns shelf and select Sort, then configure it to sort descending by your measure field.

Step 4: Add the Cumulative Percentage Line

Now it's time to build the line part of the chart that shows the running total percentage. This involves a few table calculations.

1. Drag your measure field (Number of Tickets) from the data pane and drop it onto the Rows shelf again. This will create a second, identical bar chart below the first one.
2. Right-click the second Number of Tickets pill on the Rows shelf, and select Add Table Calculation.
3. In the Table Calculation dialog box that appears, make the following selections:
4. Close the dialog box. Your second bar chart is now replaced with bars showing the cumulative percentage.

Step 5: Create a Dual-Axis Chart

At this point, you have two separate charts. Let's merge them into one visual.

• Right-click the second measure pill on your Rows shelf (the one with the table calculation).
• Select Dual Axis from the menu.

Tableau will overlay the two charts. However, it might default to showing both as something other than bars and a line (e.g., circles). We'll fix that next.

Step 6: Fine-Tune the Chart Type and Axes

In the Marks pane, you now see controls for each of your row measures and one for "All."

• Click on the control for your first measure (the original Number of Tickets SUM). Ensure the mark type is set to Bar. Adjust the color or size if you wish.
• Next, click on the control for your second measure (the running total calculation). Change its mark type to Line.
• To make sure the axes line up correctly, right-click on the secondary axis (the percentage axis on the right) and select Synchronize Axis. Now your line chart and bar chart share a common scale and layout.

Step 7: Format and Finalize

Finally, clean up the chart for clarity:

• Edit the axis titles to be more descriptive. You might label the left axis "Number of Tickets" and the right axis "Cumulative Percent of Total."
• Add a reference line at the 80% mark on the cumulative percentage axis. To do this, right-click the right axis, select Add Reference Line, and set the value to a constant of 0.8. This visually highlights the 80/20 cutoff.
• Adjust colors and labels to make the chart easy to read. Adding mark labels to the line can show the exact cumulative percentage at each point.

And that’s it! You've manually built a comprehensive, actionable Pareto chart in Tableau.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

A Faster Path: Using AI for Data Visualization

While the step-by-step process is a fantastic way to learn Tableau's capabilities, it can be time-consuming, especially when you're exploring data or answering quick follow-up questions. This multi-step process - involving sorting, dual axes, and nested table calculations - is exactly where AI-powered analytics tools offer a breakthrough.

Imagine skipping all seven steps above and simply writing:

Create a Pareto chart showing the number of tickets by ticket category.

That's the fundamental shift. Instead of you needing to know the technical steps to create the visualization - a process that can take dozens of clicks across different menus - AI tools act as your on-call analyst. You describe the final output you want in plain English, and the platform translates your request into the necessary data operations and visual configurations automatically.

Why is this such a big deal?

• Speed and Efficiency: What takes several minutes of methodical clicking can be done in seconds. This allows you to stay in the flow of your analysis, asking follow-up questions and drilling down into insights without getting bogged down by the mechanics of the software.
• Accessibility for Everyone: Not everyone on a team has the time to complete the extensive training required to master a traditional BI tool. Letting team members ask for charts directly empowers everyone to become more data-driven, without forcing them to become Tableau wizards.
• Focus on Insights, Not Process: The goal of data analysis isn't to create perfect charts, it's to uncover meaningful insights that lead to better decisions. AI lets you skip the technical busywork and jump straight to the "so what?" behind your data.

Final Thoughts

Mastering the Pareto chart in Tableau is a valuable skill that empowers you to prioritize with clarity and precision. By learning how to set up table calculations and dual-axis visualizations, you unlock a powerful way to organize, analyze, and present your data.

As you build more reports, we built Graphed to help remove the manual barriers between your data and your insights. You can connect your data sources directly and ask for a Pareto chart - or any other analysis - using simple prompts. Building what took dozens of clicks becomes a 30-second task, so you and your entire team can get the answers you need and get back to growing your business.