How to Make a Pareto Chart with AI

A Pareto chart can quickly show you exactly where to focus your effort for the biggest impact, cutting through the noise of daily business data. This article explains what a Pareto chart is, why it's so useful, and walks through how you can create one in seconds using AI instead of wrestling with spreadsheets.

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 is a Pareto Chart, Anyway?

A Pareto chart is a specific type of chart that contains both bars and a line graph. The bars display values in descending order, representing individual causes or categories, while the line represents the cumulative total.

It's built on the Pareto Principle, also known as the 80/20 rule. This principle suggests that for many outcomes, roughly 80% of the consequences come from 20% of the causes. It’s an observation, not a hard-and-fast law, but you see it everywhere once you start looking:

• Roughly 80% of your company's revenue comes from 20% of your product lines.
• 80% of customer complaints stem from 20% of your product's defects.
• 80% of traffic to your website comes from 20% of your marketing campaigns.
• 80% of inventory issues are caused by 20% of your stock keeping units (SKUs).

A Pareto chart visualizes this principle so you can instantly spot that vital "20%." A glance at the chart helps you identify the "critical few" from the "trivial many," allowing you to point your resources at the highest-leverage problems or opportunities. For example, instead of trying to fix 10 different bugs in your software, a Pareto chart will highlight the two bugs that cause 80% of all user-reported crashes.

Why Is a Pareto Chart So Useful?

The main job of a Pareto chart is to bring clarity and focus. It forces you to prioritize. Instead of spreading your resources thin across a dozen different initiatives, it points a giant arrow at the one or two things that will actually move the needle.

For marketing teams, business owners, and sales managers, this guided focus is a superpower. Here’s how it helps different teams:

• For Marketers: Are you wondering which of your 50 ad campaigns are actually driving sales conversions? A Pareto chart can show you that a handful of campaigns are responsible for the vast majority of your revenue. This lets you confidently double down on what’s working and cut the underperformers without guessing.
• For E-commerce Store Owners: Trying to figure out why your profit margins are low? A Pareto analysis might reveal that 80% of your customer support tickets are related to just a few product SKUs. Fixing the issues with those popular-but-problematic items (like faulty sizing info or poor product photos) will have a far greater impact than tweaking the descriptions on a hundred other products.
• For Sales Managers: A Pareto chart can visualize sales performance, showing that a small percentage of your sales reps are bringing in the bulk of the revenue. This doesn't mean the others aren't working, it provides an opportunity to understand what the top performers are doing differently and turn those strategies into teachable moments for the entire team.
• For Product Teams: By charting feature requests or bug reports, you can quickly see which problems are impacting the most users. It helps you build a product roadmap that prioritizes fixes and features that deliver the most value to the largest segment of your customer base.

Essentially, Pareto charts transform a fuzzy, overwhelming list of "things to do" into a clear, actionable set of priorities. You stop reacting to every fire and start focusing your efforts on the root causes that matter most.

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

The Old-School Way: Making a Pareto Chart in Excel or Google Sheets

Before AI-powered tools became accessible, creating a Pareto chart meant a trip to Spreadsheet-ville. While it's certainly possible, the manual process shows why so many people give up before they even get to the insights. It's tedious, error-prone, and requires a decent amount of spreadsheet know-how.

Here’s a simplified version of the manual workflow:

Step 1: Get Your Data

First, you have to gather your data. Let's say you're an e-commerce brand analyzing customer complaints. Your raw data might be a long list of support tickets. You need to export this data (usually as a CSV), open it in Excel or Google Sheets, and start cleaning it up.

Your raw data might look something like this:

Ticket ID, Complaint Type
101, Late Delivery
102, Damaged Item
103, Sizing Issue
104, Damaged Item
105, Wrong Item Sent
106, Late Delivery
...

Step 2: Summarize and Count Your Categories

The raw log isn't useful for a chart. You need to count the frequency of each complaint type. You’d create a summary table using formulas like COUNTIF() or a PivotTable. Then, you must sort this new list in descending order, from the most frequent complaint to the least.

After a bit of spreadsheet wrangling, you should have a table that looks like this:

Step 3: Calculate the Cumulative Percentage

This is where it gets a little tricky. You need to add a new column to calculate the running total percentage. The formula for the first row is straightforward, but for every subsequent row, you have to add the current percentage to the previous cumulative percentage. It requires careful cell referencing to get right.

Your table now needs two more columns:

Step 4: Build the Combination Chart

Finally, the moment of truth. You select your data and insert a chart. But not just any chart. You need a "Combo Chart."

You have to configure it carefully:

• The complaint counts need to be a Clustered Column (the bars).
• The Cumulative Percentage needs to be a Line With Markers.
• You then have to plot the cumulative percentage on a secondary vertical axis so that its scale goes from 0% to 100%.

After all that, if you clicked all the right buttons in the right order, you have your Pareto chart. This entire process can easily take 20-30 minutes, and that's if you know what you're doing. If you make a mistake, you're back to troubleshooting formulas. All this just to get a single chart.

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

The Modern Approach: How to Make a Pareto Chart with AI

This is the very process that AI-driven data tools now automate. The endless clicking, formula writing, and manual chart formatting are no longer necessary. Instead of spending your precious time wrangling data, you can spend it analyzing the insights.

With an AI data analyst, you skip the tedious manual work entirely. You connect your data sources directly to the tool and then simply ask for what you want in plain English. No more COUNTIFs or PivotTables. No more wrestling with chart settings. Just a simple question that gets you an answer.

Step 1: Connect Your Data Source(s)

The first and only setup step is connecting your data. Instead of weekly CSV downloads, modern analysis tools integrate directly with the platforms you already use. With a few clicks, you can connect platforms like Google Analytics, Shopify, Salesforce, HubSpot, Facebook Ads, or even a Google Sheet where you've piped in custom data. All the data is synced automatically, so your charts are always live and up-to-date, not based on last Monday's stale report.

Step 2: Describe the Chart You Want

This is where the real departure from the old way happens. Once your data is connected, you don't need to write a single formula. You just talk to the AI using a simple, conversational text prompt.

For our customer complaint example, your prompt would be as simple as:

Create a Pareto chart showing the top sources of customer complaints for the last quarter.

The AI understands your plain-language request. It knows what a "Pareto chart" is, accesses the 'customer complaints' data from your connected source, filters it by date, counts the occurrences of each complaint type, sorts them, calculates the cumulative percentage, and generates the properly formatted combination chart for you. All in a matter of seconds.

You don't need any special skills to write these prompts. You can be direct and even a little vague, the AI has enough context about the data source to figure out what you mean.

Here are a few more examples of simple prompts for creating a Pareto chart:

• "Show me a Pareto chart of blog posts by pageviews from Google Analytics for this year."
• "Make a Pareto chart breaking down our Shopify sales by product category."
• "Which landing pages are driving the most conversions? Show this as a Pareto chart."

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: Ask Follow-Up Questions to Dig Deeper

A good AI analysis tool doesn't just give you a static chart, it creates an interactive dashboard and invites a conversation about the data.

Looking at your new "Customer Complaint" Pareto chart, you immediately see that "Late Delivery" and "Damaged Item" account for over 75% of your problems. The insight is clear. But now, new questions arise. Instead of starting a new half-hour spreadsheet project for each question, you can just ask:

“For the 'Damaged Item' complaints, which products are mentioned most often?”

The AI will instantly generate another visualization, maybe a simple bar chart, showing you the three products that are constantly breaking in transit. The discovery process becomes a fluid conversation that takes minutes, not hours. This lets you drill down from a high-level problem to a specific, actionable root cause without ever leaving the dashboard.

Final Thoughts

Pareto charts are a powerful tool for finding the vital few issues or opportunities that can transform your business, helping you prioritize what truly matters. By eliminating the manual drudgery once required in spreadsheets, AI now makes creating them as easy as asking a question.

With Graphed, our goal is to eliminate that friction completely. We built an AI data analyst that connects to all your marketing and sales data sources - like Shopify, Google Analytics, and Facebook Ads - and allows you to build real-time dashboards using simple English. Instead of spending your Mondays downloading CSV files and building charts from scratch, you can get instant answers and spend your time acting on them.