Pareto Chart in Excel: How to Create and Read the Results

Charts & pivot tables · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select your category labels and counts, then choose Insert > Insert Statistic Chart > Pareto. Excel sorts the categories from highest to lowest and adds a cumulative-percentage line, making it easier to see which categories account for most of the total.

Where to find the Pareto chart option

The built-in Pareto chart is in Excel’s statistical chart menu. Arrange the data as category names in one column and their corresponding counts or totals in the next. Select both columns, including the headings, and use Insert > Insert Statistic Chart > Pareto. Excel creates a chart with descending columns and a cumulative line.

If the Pareto option is missing or unavailable, check that you are using a desktop version of Excel that supports statistical charts and that your selection contains usable data. On Excel for Mac, look under the Insert tab for the statistical chart options; the ribbon grouping or wording can differ slightly by release. Excel for the web may not offer the same chart-creation controls in every account or release. If you cannot find the built-in option, a regular combo chart can reproduce the same idea.

A Pareto chart is a particular kind of column chart, not a separate worksheet tool or formula. It combines two views of the same data: the size of each category and the running share of the total represented by categories so far.

Prepare categories and counts

A clean source table is the most important part of getting a useful result. Each row should represent one distinct cause or category, and its number should represent a comparable measure, such as incident count, returned units, or total minutes of delay. Use a clear heading for each column, and avoid blank rows inside the data.

  • Use consistent labels. “Late delivery” and “Delivery late” may be treated as different categories, even if they mean the same thing.
  • Choose one measure. Do not mix counts with dollars or minutes in the same value column.
  • Check the values. Counts should be numeric, not numbers stored as text, and should normally be zero or positive.
  • Decide how to handle blanks and rare categories. A blank label can become a confusing category. You can group small causes as “Other” when that grouping is meaningful, but retain the detailed records elsewhere.

For example, a support team might have five issue categories with counts of 8, 5, 3, 2, and 2. The total is 20. A Pareto chart ranks these causes and shows that the first two account for 13 of 20 cases, or 65%. This example uses summarized counts. If your source is a log with one row per incident, first make a count for each category, such as with a PivotTable, then chart the summarized table; this keeps the chart’s inputs easy to verify.

Create the built-in chart step by step

  1. Put category names in column A and their numeric counts in column B, with headings in the first row.
  2. Select the complete range, such as A1:B6. Include the labels and values, but exclude any grand-total row.
  3. On the Windows ribbon, choose Insert > Insert Statistic Chart > Pareto.
  4. Check that the chart uses the category names as horizontal labels and that the columns appear in descending order.
  5. Add a descriptive chart title, and adjust axis titles or formatting if the audience needs more context.

Excel calculates the running cumulative percentage from the category values. In the example, the line moves through 40%, 65%, 80%, 90%, and 100%. The line should finish at 100% when all categories are included. A chart that does not appear to do so may have an incomplete selection, unexpected blank or text values, or a confusing axis scale.

Do not include a cumulative-percentage column in the selection for the built-in Pareto chart. Excel computes that line itself. If you want to control the calculation, retain extra series, or chart a more customized data set, use a manual combo chart instead.

How to read the bars and cumulative line

The bars show the value for each category, with the largest category at the left. The cumulative line answers a different question: what proportion of the total is covered by the categories from the first bar through the current one? Read the line against the percentage axis, usually on the right side of the chart. Read the bars against the value axis on the left.

In the support example, the first bar represents 8 cases, which is 40% of the total. At the second bar, the cumulative line reaches 65%, because the two largest causes together account for 13 cases. The remaining three categories contribute 35%. That can help a team decide where to investigate first, but it does not prove that the first two causes are easy to fix or that fixing them will prevent the same percentage of future cases.

The familiar “80/20 rule” is a useful shorthand, not a promise that every data set will have exactly 80% of its impact in 20% of its categories. A Pareto chart may show a steep early rise, a gradual slope, or several categories of similar size. Use the observed pattern rather than forcing the data to fit a rule.

Build a manual Pareto chart for more control

A manual chart is useful when you have already summarized the counts or want to customize the calculations. Start with categories in A2:A6 and counts in B2:B6, sorted from largest to smallest. Add a cumulative count in C2 and a cumulative percentage in D2. With this layout, enter =SUM($B$2:B2) in C2 and fill it down through C6. The first result is 8; the final result is 20.

With counts in B2:B6 and the cumulative count in C2, enter =C2/SUM($B$2:$B$6) in D2 and fill down through D6. Format D2:D6 as percentages. The results for counts 8, 5, 3, 2, and 2 are 40%, 65%, 80%, 90%, and 100%, respectively. These formulas assume the rows are already sorted by count in descending order; sorting after calculating them can make the chart’s story misleading.

  1. Select the category labels and count values, then choose Insert > Insert Column or Bar Chart > Clustered Column.
  2. Add the cumulative-percentage series to the chart. If needed, use Chart Design > Select Data to set the series values to D2:D6 and its category labels to A2:A6.
  3. With the chart selected, choose Chart Design > Change Chart Type > Combo. Set the count series to Clustered Column and the cumulative series to Line.
  4. In the combo chart dialog, select Secondary Axis for the cumulative-percentage series, then confirm.
  5. Format the secondary vertical axis as a percentage and set its bounds to 0 and 1 if Excel does not display the range clearly.

Excel stores 100% as 1, which is why the manual percentage axis uses bounds of 0 and 1 rather than 0 and 100. The exact chart dialogs can vary slightly by update, but the key is to put the counts in columns and the cumulative percentage on a secondary axis as a line.

Make the chart easier to interpret

Give the chart a title that identifies both the subject and the measure, such as “Reported defects by cause, Q2.” Add axis titles when readers may not know whether the bars represent cases, dollars, or hours. Keep the category names readable; long labels may need a wider chart or shorter display labels, while the full names remain in the data table.

Use restrained colors and avoid decorative effects that obscure the line or make small differences look dramatic. If you add a reference line at 80%, explain that it is a chosen benchmark, not a threshold Excel discovers in the data. For a manual chart, a separate constant-value series can create such a line; for a quick report, a note beside the chart may be clearer and less distracting.

Common problems and what to check

  • The chart option is greyed out or absent: verify that the selected range has categories and numeric values, and try the desktop Excel app. For a summarized data set, a manual combo chart is a dependable fallback.
  • Categories appear in an unexpected order: check for text values, ties, or an unsuitable selection. A manual chart gives you direct control over sorting; sort the source table by the measure from largest to smallest.
  • The line or percentages look wrong: confirm that the total includes every category and that no grand-total row has been included as another category. In a manual chart, check that the percentage series uses the cumulative values and the secondary axis.
  • Several causes have been combined unexpectedly: review labels for trailing spaces, spelling variations, and blank cells. Standardize labels before counting or charting.
  • The chart does not update as expected: check whether new rows are inside the chart’s source range. Converting the source data to an Excel table can make expanding data easier to manage, but verify the chart range after adding rows.

When a Pareto chart is—and is not—the right choice

Use a Pareto chart when the question is “Which categories contribute most to this total, and how quickly does the cumulative share rise?” It works well for ranked causes, defect types, complaint reasons, or sources of delay. A regular bar chart may be better when the categories have a natural order, such as months, or when a cumulative line adds no useful meaning. A time-series line chart is generally better for showing change over time.

A Pareto chart describes the distribution; it does not establish why the leading category is large. It also depends on how categories are defined and which period or population is included. If categories overlap, events are undercounted, or the collection period is unrepresentative, the visual ranking can mislead. Treat it as a prioritization aid, then investigate the leading causes with appropriate evidence.

Frequently Asked Questions

Does Excel have a built-in Pareto chart?
Yes. In supported desktop versions, select the category and value data, then choose Insert > Insert Statistic Chart > Pareto. The chart sorts the categories and calculates the cumulative-percentage line.

Can I make a Pareto chart from raw incident rows?
First count the occurrences of each category, for example with a PivotTable, then chart the category-count summary. This makes the values and category totals straightforward to check.

Why is my Pareto chart not showing the cumulative percentage line?
Check that you selected the built-in Pareto type rather than a standard column chart. If you are building it manually, add the cumulative-percentage series as a line on a secondary axis.

Can I make a Pareto chart without the built-in option?
Yes. Sort the categories by count, calculate cumulative counts and percentages, then combine clustered columns for counts with a line for cumulative percentage on a secondary axis.

Does a Pareto chart always show an 80/20 split?
No. The chart reveals the actual distribution in your data. The 80/20 phrase is a general principle, not a required result or an Excel setting.

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.