Pareto Chart in Excel: Create and Format a Clear Analysis

Charts & pivot tables · Updated November 20, 2026

In Microsoft Excel for Microsoft 365 on Windows, select raw category observations and choose Insert > Insert Statistic Chart > Pareto to create a Pareto chart. If your data is already summarized as categories and counts, sort the counts from largest to smallest, calculate a running cumulative percentage, and plot the counts as columns with that percentage as a line on a secondary axis.

What a Pareto chart shows

A Pareto chart combines descending columns with a cumulative-percentage line. The columns show how often each category occurs, while the line shows how much of the total is accounted for as you move from the largest category to the smallest. It is useful for spotting which few causes, products, locations, or complaint types contribute most to a measured problem.

The chart is associated with the Pareto principle, often summarized as the idea that a large share of an outcome may come from a relatively small share of causes. It is a practical prioritization idea, not a rule that every dataset will follow an exact 80/20 split. A chart might show that three categories account for 70% of defects, or that the categories are distributed much more evenly. The data—not the name of the chart—determines the result.

A Pareto chart also does not prove why a problem happens or identify the best fix. It organizes counts or other comparable measures so a team can decide what to investigate first. Make sure the categories have consistent definitions and the underlying period and measurement are appropriate for the question.

Choose the right data layout

Excel has a built-in Pareto chart type, but it is important to distinguish raw observations from a summary table. The built-in statistical chart is intended to group repeated observations and count their frequencies. For example, a column listing the defect type for every inspected item can be used as raw input. A table that already contains one row per defect type and a count is summarized data; use a manually constructed combo chart for that layout to control the bars and cumulative line.

For a raw list, use one observation per row in a single column, such as Scratch, Dent, Scratch, or Missing part. Include a clear heading, avoid blank rows within the list, and exclude totals or notes. For a summarized table, use one row per category and a numeric count or other nonnegative measure in an adjacent column. Do not include a grand-total row in the chart range, because it would become an extra category.

Counts are the usual measure, but a Pareto analysis can use another comparable measure, such as the cost associated with each cause. Be explicit about what the bars represent. A chart of incident counts answers a different question from one of total repair cost, and mixing the two measures in one bar series would be misleading.

Create a Pareto chart from raw observations

In Excel for Microsoft 365 on Windows, place the raw category labels in one column, with a heading in the first row. Select the data, then choose Insert > Insert Statistic Chart > Pareto. Excel groups matching labels, orders the bars by frequency, and adds a cumulative-percentage line. If your ribbon is narrow, the statistical chart options may be inside the Insert Chart menu rather than shown as a separate large button.

  1. Check the source list for spelling variations. For example, Excel treats Scratch and scratch as separate text entries in some chart contexts, and labels such as Late delivery and Delivery late will not automatically be recognized as the same category.
  2. Select the heading and observations, but not unrelated columns or a total.
  3. Choose Insert > Insert Statistic Chart > Pareto.
  4. Add a descriptive chart title and check that the categories and scale make sense for the question.

If the Pareto option is unavailable, confirm that you are using a desktop Excel version that includes statistical charts; the built-in chart type was added in Excel 2016 and is present in current Microsoft 365 desktop Excel. Excel for Mac has statistical chart options in the Insert chart controls, though their placement can differ by release. If a chart type is not exposed in your Excel build, a manually prepared summary table and combo chart is a dependable alternative.

Build one from category counts

Suppose a service team has summarized 100 complaints: Delivery delay, 40; Damaged item, 25; Wrong item, 15; Billing issue, 12; and Other, 8. Put the category names in A2:A6 and their counts in B2:B6, with headings in A1 and B1. Sort the rows by count in descending order using Data > Sort, and sort the count column Largest to Smallest while keeping the category column in the same rows.

With names in A2:A6 and counts in B2:B6, enter the following in C2 to calculate the running share of all complaints, then fill the formula down through C6: =SUM($B$2:B2)/SUM($B$2:$B$6). Format C2:C6 as Percentage. The values are 40%, 65%, 80%, 92%, and 100%: for example, the first two categories contribute 40 + 25 = 65 complaints out of 100.

With headings in A1:C1 and data in A2:C6, select A1:C6, then choose Insert > Combo > Create Custom Combo Chart. Set the count series to Clustered Column and the cumulative percentage series to Line. Select Secondary Axis for the cumulative series, then confirm the chart. In some Excel builds the combo-chart controls may be presented through Insert Combo Chart rather than the exact custom-combo dialog, but the goal is the same: columns for counts and a line for cumulative share.

Format the right-hand vertical axis as a percentage and set its bounds to 0 and 1 when the axis options allow numeric bounds. The formula returns decimal values from 0 to 1 even though cells display them as percentages. Keep the left axis for counts. Give the chart a title that identifies both the subject and measure, such as Complaint causes by count.

Format and interpret the chart

Read the bars from left to right: the first bar is the largest category, and later bars contribute progressively smaller amounts. Follow the line against the right-side percentage axis. Its point above the second category in the example is 65%, meaning the two largest complaint categories account for 65% of all complaints in the table. The line reaching 100% at the final category is expected because all categories together make up the total.

  • Use a useful title and axis labels, especially if the bar measure is not a simple count.
  • Keep category names readable. Widen the chart, shorten labels carefully, or use a horizontal bar chart if long labels dominate the display.
  • Use a restrained color scheme. A highlighted first bar can draw attention, but colors should not imply a ranking that the data does not support.
  • Consider data labels only when they remain legible. Labels on every bar and line point can clutter a chart with many categories.
  • For a manual chart, make the right axis visibly distinct as a percentage scale so readers do not confuse it with the count axis.

A cumulative threshold such as 80% can be useful for prioritization, but it is not a universal cutoff. In the example, the first three categories reach 80%. That tells the team where 80% of the recorded complaints fall; it does not mean the other two categories are unimportant or that addressing the first three will automatically eliminate that share.

Common problems and fixes

If bars appear in alphabetical order or the line rises and falls, check the source order. A manual chart requires counts to be sorted largest to smallest before calculating cumulative percentages. Sorting only the counts without their matching category names corrupts the data, so sort the entire table by the count column.

If the cumulative line is flat, missing, or outside the visible plot, check that the cumulative values are numeric percentages rather than text. In a combo chart, make sure the cumulative series is assigned to a line and plotted on the secondary axis. Set that axis to a 0-to-1 range and percentage number format if it displays decimals or an unexpected scale.

If categories that should match are split into separate bars, standardize the source labels before building the chart. Look for extra spaces, inconsistent abbreviations, spelling variants, or labels that differ only by punctuation. Also verify that a numeric count column contains numbers rather than values stored as text.

Many tiny categories can make the chart hard to read. You may group genuinely minor categories into Other, but do so transparently: add their counts together and note what the group contains. Do not merge categories merely to make a preferred cause look more prominent. Keep the underlying detailed table so readers can inspect what was grouped.

Built-in chart or manual combo chart?

Use the built-in Pareto chart when you have a clean list of individual observations and want Excel to count the repeated values. It is quick and automatically orders the frequencies. Use the manual combo-chart method when you already have a frequency table, want precise control over the cumulative calculation, need to chart costs or another summary measure, or want to decide how categories are grouped.

The manual approach takes more preparation and requires the cumulative formula, but it also makes the chart logic visible in worksheet cells. That transparency is useful when someone needs to audit the total, change a category, or reproduce the analysis. A built-in chart is convenient, but you should still verify that its labels and counts reflect the source data as intended.

Keep the analysis reliable

A Pareto chart is only as sound as its categories and collection process. Define what counts as an event, use the same observation period when comparing categories, and avoid treating counts as rates when the categories had different exposure. For example, a department handling twice as many orders may naturally record more incidents; incidents per order may be a more useful comparison than raw totals.

When the source data changes, check whether the chart updates as intended. A normal chart based on a fixed cell range may not include newly appended rows automatically. An Excel Table can help keep source ranges expanding as rows are added, but a manually calculated cumulative series may also need its formulas and chart range extended. Recheck the sort order and final cumulative value after updates; the last value should equal 100% when the categories cover the full total.

Frequently Asked Questions

Does Excel have a built-in Pareto chart?
Yes. Current desktop Excel for Microsoft 365 includes Pareto under Insert > Insert Statistic Chart. It is designed for raw observations that Excel can group and count. A category-and-count summary is usually clearer as a manually built combo chart.

How do I sort a Pareto chart from highest to lowest?
For a built-in chart, Excel orders categories by frequency. For a manual chart, sort the whole category-and-count table by the count column from Largest to Smallest before calculating the cumulative percentage and creating the chart.

Why does my Pareto chart not show an 80/20 split?
The 80/20 phrase is a rough heuristic, not a guaranteed property of data. A valid Pareto chart can show a different distribution, including one where many categories contribute similar amounts.

Can I make a Pareto chart from percentages or costs?
Yes, if each category has a comparable numeric measure. Sort the measures from largest to smallest, calculate each running total divided by the grand total, and use the running share as the line. State clearly whether the bars represent counts, cost, or another measure.

Can I create a Pareto chart in Excel for the web?
Chart options can differ between Excel for the web and desktop Excel. If the Pareto statistical chart type is not available in the web ribbon, prepare the summary and cumulative-percentage columns and create a column-and-line combo chart, or open the workbook in desktop Excel.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.