How to Make a Pareto Chart in Excel

To make a Pareto chart in Excel, select your data and choose Insert > Insert Statistic Chart > Pareto. That built-in option works best with a column of repeated raw observations. If you already have a summary table of categories and counts, build a combo chart instead: sort counts from largest to smallest, calculate the cumulative percentage, then plot counts as columns and the percentage as a line on a secondary axis.

A Pareto chart highlights which categories account for the largest share of a total. It combines bars ordered from highest to lowest with a cumulative-percentage line, making it easier to decide which causes, products, or issues to investigate first. It does not prove that a category caused a problem; it shows how the recorded values are distributed.

What You’ll Need

Excel for Microsoft 365 on Windows for the ribbon steps below. Excel for Mac has similar chart options, though ribbon labels and placement can differ slightly.
A clear question and a consistent measure, such as number of defects, complaints, or hours lost.
Either one column of raw category observations for the built-in Pareto chart, or a two-column summary table with category names and counts for the manual method.
Avoid merged cells and blank rows inside the data. If you are working with a summary table, have a separate column available for cumulative percentages.

Step-by-Step

Choose the measure and prepare the data. Decide what one bar should represent. For example, a service team might count each customer complaint by reason. Use a consistent reporting period and define categories clearly: do not combine “late delivery” with “missing item” in one row unless that is genuinely how you want to analyze the data.

If each event is recorded on its own row, use the raw-data method in step 3. If you already have a count for each category, use the summarized-data method in steps 4 and 5. Do not feed a summary table into the built-in chart as if its count column were a list of observations; the chart may count the values rather than use them as category frequencies.
Check and clean the source. Remove completely blank rows and correct inconsistent labels such as “Packaging” and “packaging,” which Excel may treat as different categories. Confirm that counts are numeric, not numbers stored as text. In a summary table, exclude totals and subtotals from the chart range; including a grand total as a category will distort the bars and cumulative line.

Keep the source in a simple layout with headers in the first row. For a summary, use columns such as Issue and Count. Before charting, check that every count is nonnegative and that the categories are mutually understandable. If a category has zero occurrences, decide whether it adds useful information before including it.
Create a Pareto chart from raw observations. Put one observation per row in a single column, with a header such as Defect type. For example, the entries might repeat “Scratch,” “Wrong size,” and “Late arrival.” Select the header and all populated cells in that column, then choose Insert > Insert Statistic Chart > Pareto. Excel counts the repeated category values and orders the bars from most frequent to least frequent.

Review the horizontal labels and bar heights. If Excel has included a blank as a category, return to the source and remove empty records, then recreate or update the chart. The built-in chart is useful when you want Excel to count repeated records automatically. It is less suitable when you need to preserve a pre-calculated frequency table or carefully control a combined “Other” category.

On Excel for Mac, look on the Insert tab for the Statistical Chart or Histogram chart menu and choose Pareto; exact grouping can depend on the build. Excel for the web may not expose the same chart controls in every account. If you cannot find Pareto, use the summarized-data method below, which uses a regular combo chart.
Prepare a summarized table for a controlled chart. Enter each category once in column A and its count in column B, with headers in row 1. Sort the entire table by Count from Largest to Smallest using Data > Sort. Make sure the category and count columns move together. For a worked example, use these counts: late delivery 40, damaged item 25, wrong item 15, missing part 12, and other 8. The total is 100.

In C1, enter Cumulative %. With categories in A2:A6 and counts in B2:B6 already sorted descending, enter this in C2:

=SUM($B$2:B2)/SUM($B$2:$B$6)

Format column C as Percentage and fill the formula down through C6. With the example counts, the values are 40%, 65%, 80%, 92%, and 100%. The last value should be 100% when every row is included. If you add or remove categories, adjust the range in the formula so it covers all the counts.
Insert a combo chart. Select A1:C6, including the headers. Choose Insert > Insert Combo Chart > Create Custom Combo Chart. In the chart dialog, set the Count series to Clustered Column and the Cumulative % series to Line. Select Secondary Axis for Cumulative %, then choose OK. The left axis now measures counts, while the right axis measures the cumulative share.

If the chart dialog does not identify the series correctly, check that the first row contains headers and that each selected column is numeric apart from its header. You can also open Chart Design > Change Chart Type and select the combo setup there. The secondary axis is important: without it, percentage values may look almost flat next to counts such as 40.
Format the axes and explain the chart. Click the right-hand vertical axis, right-click, and choose Format Axis. Set the number format to Percentage if Excel has not done so. The cumulative line should begin at the first category’s share and end at 100%. Check that its scale reaches 100% (or 1 if the chart uses decimal values); avoid a misleading scale that makes a small change appear dramatic.

Use Chart Design > Add Chart Element to add a chart title and axis titles. A useful title names the measure and period, such as “Customer complaints by reason, Q2.” Label the left axis with the unit being counted and the right axis as cumulative percentage. Keep category names readable; widen the chart or reduce label font size rather than relying on unexplained abbreviations.
Check the reading before sharing. Confirm that the bars descend from left to right and that the line never goes down. For the example, the first two categories account for 65% of the 100 recorded complaints, and the first three account for 80%. That tells readers how the counts accumulate; it does not mean the first three categories are necessarily the only ones worth addressing.

If you want to show a reference point, add a clearly labeled 80% guide line to the summarized chart as an additional series, or explain the relevant cumulative value in a callout. Do not assume every Pareto chart must use an 80% cutoff. Choose a threshold that fits the decision, and say how you calculated the underlying counts.

Common Mistakes

Using the wrong input format. The built-in Pareto chart is intended to count repeated raw observations. A table that already lists categories beside frequencies calls for the manual combo-chart approach. Otherwise, the chart can misrepresent the counts by treating the frequency values as individual observations.

Sorting only one column. If you sort counts without sorting their matching category names, the chart assigns numbers to the wrong labels. Select the whole table before sorting, and verify that the largest count is paired with the correct category. Also exclude total rows, which are not actual categories.

Mixing units or periods. Counts of calls, costs, and hours cannot be combined as though they were the same measure. Likewise, comparing categories collected over different time periods may mislead. Choose one measure and a consistent time window, or make separate charts.

Confusing cumulative percentage with category percentage. A category’s individual share is its count divided by the total. The Pareto line shows the running total of those shares. Label the right axis as cumulative percentage so viewers do not interpret the line as a separate bar-by-bar rate.

Leaving unclear categories or missing records. Inconsistent spelling creates duplicate bars, while blank or miscoded observations can change totals. State how “Other” is defined and avoid hiding a large number of records in it. If the source is incomplete, make that limitation visible.

Tips

Use a descriptive title and include the date range, source, or population when that context matters. A chart titled “Defects” is harder to interpret than one that states the product line and month. Keep the original data in a separate worksheet or table so readers can trace the chart back to its source.

For a long list, consider grouping only genuinely small categories into “Other,” and document the rule. If you combine them, do it after calculating the individual counts and make clear that the grouped bar represents several categories. Keep the main categories in descending order and place “Other” at the end when that makes the chart easier to understand.

Use a table formatted with Home > Format as Table for a summary that changes regularly. When adding categories, check that the chart range and cumulative-percentage formula include the new rows. Excel tables often expand with added rows, but chart series and formulas should still be checked after a structural change.

Keep the chart simple: one bar series and one cumulative line are usually enough. Use contrasting colors, readable labels, and restrained gridlines. If you need to compare two periods, separate charts or a clearly designed comparison may be easier to interpret than adding several lines to one Pareto chart.

Troubleshooting

Pareto is missing from the Insert menu. Confirm you are using a supported desktop version of Excel and that you have selected a single column of raw categories. In Excel for the web or an older installation, the chart type or its controls may not be available. Use the summarized method: calculate cumulative percentages and create a column-and-line combo chart with the line on the secondary axis.

The bars are not in descending order. For a built-in chart, check the source values and chart settings; for a summary table, sort the full category-and-count range by count descending. If you edit or add values later, sort again. Do not manually rearrange just the labels or bars, because that breaks their relationship.

The cumulative line is flat, missing, or on the wrong scale. In a manual chart, check that the Cumulative % series contains numeric values, not text such as “65%” typed into cells as text. Open Chart Design > Change Chart Type, set that series to Line, and enable its Secondary Axis option. Format the right axis as Percentage. If the line falls, check the sorting and cumulative formula.

The last cumulative value is not 100%. Check that the formula’s denominator includes every count and that the formula was filled to the final category. Remove excluded totals from the source range. If the displayed result is slightly below 100% due to rounding, increase the percentage decimal places; the underlying value may still equal 100%.

Labels are cut off or crowded. Enlarge the chart area, widen the worksheet columns before copying the chart, or reduce label font size. Long labels can be shortened in the source if the meaning remains clear, with full names retained in an accompanying table. Avoid rotating labels so far that they become difficult to read.

Frequently Asked Questions

What is the difference between a Pareto chart and a regular bar chart?
A Pareto chart orders categories from largest to smallest and adds a cumulative-percentage line. A regular bar chart can use another order and usually has no cumulative line.

Can I make a Pareto chart from a table of counts?
Yes. Sort the count table descending, calculate cumulative percentages, and create a combo chart with columns for counts and a line on a secondary axis. This gives you control over the exact frequencies.

Why does my Pareto chart not show an 80% line?
The built-in chart shows the cumulative percentage but does not necessarily add a separate 80% reference line automatically. Add one as a separate series or annotate the chart, and label it clearly.

Does Excel automatically sort Pareto bars?
The built-in Pareto chart orders its counted categories. For a manually built combo chart, sort the summary table by count from largest to smallest before charting and repeat the sort after the data changes.

Can I use negative values in a Pareto chart?
Negative counts do not make sense for frequency-based Pareto analysis. Check the source and use nonnegative counts for the same measure. If you are analyzing another kind of value, consider whether a Pareto chart is appropriate.

Can I update the chart when new records arrive?
Yes. Add records to the raw-data source and verify that the chart range includes them. For a summarized chart, update the counts, sort again, and confirm that the cumulative formula and chart series extend through the last category.

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.