Create a Pareto Chart in Excel: Steps, Tips, and Examples

Charts & pivot tables · Updated November 19, 2026

To create a Pareto chart in Excel for Microsoft 365 on Windows, select a table containing category names and counts, then choose Insert > Insert Statistic Chart > Pareto. Excel sorts the categories from largest to smallest and displays a cumulative-percentage line, helping you see which causes account for the biggest share of a total.

What a Pareto chart shows

A Pareto chart combines two views of the same data. Its columns show the size of each category, arranged from greatest to least, and its line shows the running total as a percentage of all observations. The first column is the largest category; the point above each column indicates how much of the overall total is accounted for by that category and all the categories before it.

This makes the chart useful for prioritizing issues, defects, customer complaints, support requests, or reasons for delays. For example, a service team might count complaints by type. A Pareto chart can show whether a few complaint types make up most of the reported cases, giving the team a starting point for investigation.

The chart is associated with the Pareto principle, often summarized as an 80/20 relationship. That phrase is a rule of thumb, not a promise that every dataset will have an exact 80/20 split. A useful chart may show a concentration near 80 percent, a more even distribution, or a different pattern entirely.

Prepare the data before charting

Arrange the source data in two columns, with one row per category. Use a clear header for each column, such as Cause and Count. The count should be a nonnegative number representing the same kind of measurement in every row. Do not include a manually calculated total row in the selection for Excel’s built-in Pareto chart.

  • Use specific, mutually understandable category labels, such as “Late delivery” rather than a broad label such as “Other issue.”
  • Combine duplicate labels before charting so the same cause is not split across multiple bars.
  • Check that counts are numeric, not numbers stored as text, and decide how to handle blank categories.
  • Keep the measurement consistent. Do not mix counts of incidents with dollar amounts or percentages in one count column.

For example, enter Delivery—42, Damaged item—25, Billing—18, Website—9, and Other—6. These counts total 100. If several source records describe the same cause, summarize them first—for instance, with a PivotTable—or use a consistent counting process. A chart cannot correct inconsistent categorization in the source data.

Create the built-in Pareto chart

  1. Select the category labels and their counts, including the column headers. For the example above, that is the two-column table from A1:B6.
  2. On the ribbon, choose Insert > Insert Statistic Chart > Pareto.
  3. Excel inserts a chart with descending columns and a cumulative-percentage line. Move or resize it so the labels and data are readable.
  4. Select the chart title and replace it with a descriptive title, such as Customer complaints by cause. Add axis titles if readers may not understand what the counts measure.

The built-in chart is usually the quickest choice when you have one category field and one numeric count field. Excel handles the descending order and cumulative line for you. The chart’s exact formatting controls can depend on the Excel release and platform; on a Mac, look under the Insert tab for the statistical chart options. If Pareto is not available in your version, or if you need more control over the calculations, use the manual method below.

Build a Pareto chart manually

A manual chart is useful when you want visible calculation columns, a customized threshold line, or a chart type that is available in more Excel versions. First sort the categories by count in descending order. The worked example below uses rows 2 through 6, with category names in A2:A6 and counts in B2:B6. Put the headers Cause, Count, Cumulative count, and Cumulative percent in A1:D1.

With names in A2:A6 and counts in B2:B6 already sorted from highest to lowest, enter this in C2 to calculate the running count, then fill it down through C6: =SUM($B$2:B2). The results are 42, 67, 85, 94, and 100. The dollar signs keep the start of the range fixed as the formula is copied down.

With the same layout and the running totals in C2:C6, enter this in D2 and fill it down through D6: =C2/SUM($B$2:$B$6). Format D2:D6 as percentages. The results are 42%, 67%, 85%, 94%, and 100%. These figures are cumulative: for example, 67% means the two largest categories together account for 67 of the 100 observations.

To chart the values, select A1:B6, then hold Ctrl on Windows and select D1:D6 as a second range. Choose Insert > Combo > Create Custom Combo Chart, assign Count to a clustered column and Cumulative percent to a line, and select the secondary-axis option for the percentage line. The secondary axis is necessary because the counts and percentages use different scales. Format that axis as a percentage and, if appropriate, set its bounds from 0 to 1. On a Mac, use Command rather than Ctrl to add a separate selection where supported; if selecting nonadjacent ranges is awkward, create the chart first and add the cumulative-percent series through the chart’s data-selection controls.

Format the chart for clear decisions

A Pareto chart should make the order and concentration of categories easy to see. Keep the descending columns visually distinct from the cumulative line, and avoid decorative effects that compete with the data. Use a chart title that identifies both the subject and, where relevant, the reporting period. “Defects by type, October” is more informative than “Pareto chart.”

  • Label the count axis with the unit being counted, such as cases, units, or dollars.
  • Make sure the cumulative line uses a percentage axis, not the count axis.
  • Use data labels selectively. Labeling every bar can clutter a chart with many categories.
  • Keep category names readable. Widen the chart, wrap labels, or shorten wording consistently rather than shrinking the text excessively.
  • If you add an 80% reference line, label it clearly as a chosen benchmark, not as a result guaranteed by the Pareto principle.

In a manually built chart, the cumulative percentage must reach 100% at the final category when the total is positive and every category is included. If it does not, check the formula range and confirm that no rows were omitted. In a built-in chart, verify that the selected source range includes all intended categories.

Choose between the built-in and manual methods

Use Excel’s built-in Pareto chart when speed and a standard presentation matter most. It automatically orders the categories and calculates the cumulative line, reducing the chance of a sorting or running-total mistake. It is a good fit for a quick analysis from a clean, two-column summary.

Choose the manual method when you need to inspect or reuse the cumulative calculations, add a reference line, adapt the chart for a version without the built-in chart type, or apply special formatting. It also makes the calculation logic explicit for readers reviewing the workbook. The trade-off is maintenance: if the data changes, the sort order, formulas, and chart source need to remain aligned.

For larger raw datasets, a PivotTable can summarize records by category before you make a Pareto chart. This is often more reliable than manually counting repeated entries. A PivotChart is useful for interactive summaries, but its available chart options and behavior can differ from a regular chart; if it does not produce the desired Pareto layout, chart the PivotTable summary or use the manual method.

Common problems and how to fix them

The bars are not in descending order. The built-in Pareto type should order categories by size. If you made a standard column chart manually, sort the source count table largest to smallest before charting. When using a PivotTable, sort the count field in descending order.

The line looks flat or is hard to interpret. Check that the cumulative-percent series is plotted as a line on a secondary axis. If it shares the count axis, percentages may appear close to zero relative to large counts. Format the secondary axis as Percentage.

The cumulative line does not end at 100%. In a manual chart, confirm the final running total includes every count and that the denominator covers the full count range. Also check for hidden or excluded categories. A blank or zero total needs special handling because a percentage cannot be calculated from a zero denominator.

Categories appear twice or labels are missing. Clean the source first. Extra spaces, different spelling, and inconsistent capitalization can make what people consider one category appear as multiple categories. Empty labels can also create confusing bars. Standardize labels and aggregate duplicates before plotting.

The chart changes unexpectedly after editing data. Confirm the chart’s source range includes new rows. If the data will grow, converting the source range to an Excel Table using Insert > Table can make it easier to manage expanding data, though you should still verify that the chart includes the added categories and that the order remains correct.

Interpret the results responsibly

The chart describes the data you collected; it does not establish why a category is large or prove that addressing it will solve the underlying problem. A high count of “late delivery,” for example, may reflect a genuine operational issue, but it could also be affected by how reports are submitted, how categories are defined, or the period covered. Check the data definitions and collection process before treating the ranking as a complete explanation.

Counts are not always the most useful measure. If one category causes a small number of very expensive failures, a chart by incident count may place it below frequent but minor problems. Consider making a separate Pareto chart by cost, time lost, or another meaningful measure, and label it clearly. Do not combine unlike measures in one series. Comparing count-based and impact-based charts can reveal different priorities without implying they answer the same question.

Also state the time period and population represented. A Pareto chart of complaints from one month may have a different ranking from a full year. If the number of observations is small, treat the percentages as a description of that sample rather than a dependable forecast. The chart is a prioritization aid; follow-up investigation is needed to decide what action is justified.

Frequently Asked Questions

Can Excel make a Pareto chart automatically?

Yes. In supported desktop versions, select category and count data, then choose Insert > Insert Statistic Chart > Pareto. Excel creates descending columns and a cumulative-percentage line. If the option is unavailable, calculate cumulative percentages and make a combo chart manually.

How do I sort a Pareto chart from largest to smallest?

The built-in Pareto chart sorts categories by count automatically. For a manual chart, sort the source table by the count column in descending order before charting. Keep each category and its count together when sorting.

Does a Pareto chart always follow the 80/20 rule?

No. The 80/20 idea is a commonly used heuristic, not a required chart result. Your data may show 80% of the total in a few categories, or it may be distributed more evenly. Report the percentages the data actually produces.

Why does my cumulative percentage exceed 100%?

Check whether the running-total formula is accidentally adding the same rows more than once, whether the denominator omits categories, or whether negative values are present. A standard count-based Pareto chart assumes meaningful nonnegative values; investigate unusual inputs before interpreting the line.

Can I make a Pareto chart from raw data?

Summarize raw records into one count per category first, using a PivotTable or another consistent aggregation method. Then chart that summary. A simple category-and-count table is the clearest input for the built-in Pareto chart and makes the results easier to validate.

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.