How to Draw a Pareto Chart in Excel

Charts & pivot tables · Updated November 19, 2026

To draw a Pareto chart in Excel for Microsoft 365 on Windows, select a table with category names and their counts, then choose Insert > Insert Statistic Chart > Pareto. Excel creates descending bars and a cumulative-percentage line; if you need more control over the calculation or formatting, build a combo chart from a sorted summary table instead.

What a Pareto chart shows

A Pareto chart combines two views of the same data. Its bars represent values for individual categories, arranged from largest to smallest, while its line shows the cumulative share accounted for as you move from left to right. It is useful when you want to identify which causes, defects, requests, or expenses contribute most to a total.

For example, a support team might count incoming tickets by issue type. The bar for “password reset” shows the number of tickets in that category. The line at that category shows the share of all tickets represented by password resets and every category with a larger bar before it. The chart makes both the biggest individual category and the combined contribution of the leading categories visible.

The chart is associated with the Pareto principle, often summarized as an 80/20 rule. Treat that as a prompt to investigate concentration, not a promise that exactly 80 percent of a result will come from 20 percent of causes. Your data may follow a very different pattern.

Prepare category and count data

For a clear chart, start with a summarized table: one row per category and one numeric count or measure per row. Include headers, use consistent category names, and exclude totals from the rows you plan to chart. A total row included as if it were another category can distort the display or appear as an extra bar.

  • Use categories that are specific enough to be actionable, but not so detailed that nearly every row is unique.
  • Count each observation once, and decide how to handle missing or uncategorized records before charting.
  • Check that the measure is meaningful. Counts suit event frequency; costs or hours can be used when the question is about contribution to total value.
  • For categories with identical values, expect a tie. Their order may not carry meaning, so avoid interpreting small rank differences as important.

Suppose a quality report contains five defect types and these counts: scratches, 40; missing parts, 25; wrong labels, 15; damaged boxes, 10; and other, 10. The total is 100. A chart based on these summary counts answers how the recorded defects are distributed. If you instead have a list of individual inspection records, first summarize those records by defect type, for example with a PivotTable, then chart the resulting categories and counts.

Create the built-in Pareto chart

In Excel for Microsoft 365 on Windows, put category names in one column and corresponding numbers in the next, with a header in each column. Select the headers and data rows, then use these steps:

  1. Open the Insert tab.
  2. In the Charts area, choose Insert Statistic Chart, then choose Pareto.
  3. Check that the categories, bars, and cumulative line make sense. If Excel interpreted the selected range incorrectly, undo and select just the two-column summary table, including its headers.
  4. Click the chart title and replace it with a useful description, such as “Defects by Type and Cumulative Share.”

The built-in chart sorts categories by value in descending order and calculates the cumulative percentage for the line. That is convenient for a quick analysis because you do not have to create a separate cumulative column. It also means the chart’s display order may not match the order of rows in your source table. The underlying worksheet data are not necessarily rearranged when the chart sorts its categories.

Excel for Mac has a similar statistical-chart option in versions that include Pareto charts, though the ribbon layout can differ. If the option is unavailable in your Excel version or in Excel for the web, the manual combo-chart method below provides a reliable alternative. You can also use that method when you want to control the cumulative calculation explicitly.

Build a manual Pareto chart with a combo chart

A manual chart is useful when you need predictable calculations, a custom threshold line, or a design that the built-in chart does not provide. First sort the summary data by the count column from largest to smallest. Then add cumulative counts and cumulative percentages. Use the following example layout: category names in A2:A6 and counts in B2:B6, with headers in A1 and B1.

With the first count in B2 and all counts in B2:B6, put this formula in C2 to calculate the running total, then fill it down through C6: =SUM($B$2:B2). In the example, the values in C2:C6 are 40, 65, 80, 90, and 100.

With the same counts in B2:B6 and the running totals in C2:C6, enter this formula in D2 and fill it down through D6: =C2/SUM($B$2:$B$6). Format D2:D6 as Percentage. For the example, the results are 40%, 65%, 80%, 90%, and 100%. The last value should be 100% when every category is included and the denominator is nonzero.

To chart the categories, counts, and percentages, select the category and count columns, then hold Ctrl while selecting the percentage column as a second, nonadjacent range. Choose Insert > Recommended Charts > All Charts > Combo. Set the count series to Clustered Column, set the cumulative percentage series to Line, and check Secondary Axis for the percentage series. Confirm the chart, then add a title and axis labels as needed. If your Excel build presents a Combo option directly in the Insert charts menu, you can use that route to reach the same chart-type settings.

The secondary axis matters because counts and percentages use different scales. Without it, the percentage line may appear flattened or misleading. Format the secondary vertical axis as a percentage and, if appropriate for your data, set its minimum to 0 and maximum to 1 (Excel’s underlying values for 0% and 100%). Keep the categories sorted by count; otherwise, the cumulative line will not describe a largest-to-smallest Pareto sequence.

Choose between the built-in and manual methods

Use Excel’s built-in Pareto chart when you have a clean category-and-count summary and want a quick result. It handles the descending order and cumulative line for you. The manual approach is preferable when you need to audit every intermediate percentage, apply a threshold, adapt the chart to nonstandard measures, or work in an Excel environment without the Pareto chart type.

For a small, static report, either method is usually straightforward. If the source data change frequently, consider making the source a structured Excel Table with Insert > Table, then refresh or update the summary as new records arrive. A PivotTable can help summarize raw event records, but check that the chart refers to the current summary after refreshing. The manual formulas shown above use fixed ranges; extend those ranges when adding categories or convert the source and calculations into a layout that includes new rows.

Format the chart so it can be read

Good formatting helps readers distinguish the two measurements and understand the takeaway without guessing. Keep the bars in descending order, use a contrasting line color, and make sure the line is visible against the columns. A chart title should name the measure and subject rather than say only “Pareto Chart.” If the audience may not know the chart type, label the left axis with the count or unit and the right axis as cumulative percentage.

  • Use a descriptive unit, such as “Number of tickets” or “Repair cost,” rather than a vague axis title like “Value.”
  • Set the percentage axis to run from 0% to 100% when the chart represents a complete set of categories.
  • Keep category labels readable. If names are long, widen the chart, shorten labels carefully, or use a horizontal layout created with a manual chart.
  • Consider data labels only when they improve readability. Labeling every bar and every point can make a busy chart harder to scan.

A vertical reference line at 80% can be added as a separate series in a manual combo chart, but it is optional. It should not be presented as a universal cutoff. A business may choose a different target, and the useful decision may depend on the cost, severity, or ease of addressing a category—not merely its position on the chart.

Common problems and how to fix them

If the chart shows one bar per record instead of one per issue type, the source is probably raw observations rather than a category summary. Summarize the observations first. If category names are repeated in raw records, Excel needs a count for each distinct category before a conventional category-based Pareto chart can show the intended result.

If the cumulative line does not end at 100%, check for omitted categories, a total row included in the calculation, blank or nonnumeric counts, or a formula range that stops too early. In a manual chart, verify that the cumulative percentage denominator includes exactly the counts shown. If the line descends, the categories may not be sorted from highest count to lowest, or the cumulative values may reference the wrong rows.

If the bars appear in an unexpected order, distinguish the chart’s display order from the order of the source worksheet. For a built-in chart, Excel may sort the plotted categories automatically. For a manual chart, sort the source summary before calculating the running totals. If several categories are tied, a different order among those tied values can still produce the same cumulative contribution at the end of the tied group.

If the line is hard to see, confirm that it is a line series on the secondary axis rather than a column series sharing the count axis. In the manual combo chart, edit the series chart types and secondary-axis setting. Also check that the percentage values are stored as decimals such as 0.4 and formatted as 40%, rather than typed as 40 and then formatted as a percentage, which would display as 4,000%.

Interpret the result with care

A Pareto chart describes the distribution in the data you supplied; it does not prove why the leading categories occur or what intervention will work. A high bar means a category contributes many observations or a large amount to the chosen measure. It does not necessarily mean that the category is the most harmful, most expensive to fix, or easiest to prevent. Add context such as severity, time period, sample size, or intervention cost before deciding what to address.

Make sure categories are mutually exclusive if you want their counts to add cleanly to the total. If one incident can be assigned to several categories, category counts may overlap; in that case the cumulative percentages can exceed 100% or no longer represent a share of unique incidents. Explain the counting rule alongside the chart. Also state the reporting period: a Pareto pattern for one month may differ from a pattern across a full year.

Frequently Asked Questions

Does Excel automatically sort a Pareto chart?

The built-in Pareto chart orders its plotted categories from largest to smallest. A manual combo chart does not automatically establish the correct cumulative sequence, so sort the source counts in descending order before calculating running totals.

Can I make a Pareto chart from raw data?

For category-based data such as issue types, summarize the raw records into one row per category with a count or other measure, then chart that summary. A list of individual records is not the same as a category-and-count table.

Why does my cumulative line not reach 100%?

Check that every intended category is included, the denominator covers the same counts as the chart, and no total row has been counted as a category. In a manual chart, make sure the final running total includes the last data row.

Can a Pareto chart show costs instead of counts?

Yes. Use a consistent cost measure for each category if the question is which categories contribute most to total cost. Label the axis and chart clearly, and do not describe a cost-based chart as a frequency chart.

Is the 80/20 rule required for a Pareto chart?

No. The chart displays descending category values and their cumulative share. The leading categories may account for more or less than 80% of the total; the rule is a common heuristic, not a required chart property.

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.