Yes. In Excel for Microsoft 365 on Windows, select a column of raw category records, then choose Insert > Insert Statistic Chart > Pareto. If you already have a table of category counts, create a clustered-column and line combo chart instead, using a cumulative-percentage series for the line.
What a Pareto chart shows
A Pareto chart combines bars and a line to show which categories account for the largest share of a total. The bars are ordered from highest count to lowest, and the line tracks the cumulative percentage as you move across them. It is commonly used to examine defects, customer complaints, support requests, expenses, or other records grouped into causes.
The chart is associated with the Pareto principle, often summarized as the idea that a small number of causes may account for a large share of an outcome. That is a useful prompt for investigation, not a rule that every dataset will follow a precise 80/20 split. A chart can show that a few categories dominate, or that the contribution is spread more evenly.
It is also important to distinguish a Pareto chart from a regular bar chart. A regular bar chart can show categories in any order and does not necessarily include a cumulative percentage. The descending order and cumulative line are what make the Pareto view useful for prioritizing attention.
Choose the right data setup
Excel offers a built-in Pareto statistical chart for raw records: each row contains one observed category, such as one defect type per inspected item. Excel counts the occurrences and arranges the categories. Use this route when the source data is a list of individual events rather than a pre-counted summary.
If your data already has one row per category and a count beside it, a custom combo chart gives you more control. For example, a summary table might contain five defect types and the number of times each appeared. You can sort that table, calculate the cumulative share, and plot the counts as bars with the cumulative share as a line. Do not feed a summary table into the raw-record method and assume Excel will interpret the two columns as category-frequency pairs.
Before charting, make category names consistent. Entries such as Wrong label, wrong label, and Wrong Label may be treated as separate categories. Correct spelling differences, decide how to handle blanks, and use a clear header if you have one. Also confirm that the counts represent comparable observations and the same time period.
Create a Pareto chart from raw records
- Put each record’s category in a single column, with one incident or observation per row. For example, a service log could have a Cause column with entries such as Damaged item or Late delivery.
- Select the category values, including the header if present. Avoid selecting unrelated columns such as dates, notes, or customer IDs.
- On the Windows ribbon, choose Insert > Insert Statistic Chart > Pareto. Excel creates a chart with the categories ranked by frequency and a cumulative-percentage line.
- Give the chart a specific title, such as Customer complaints by cause, and add axis titles if the meaning of the count or percentage is not obvious.
- Check the chart against the source records. Confirm that the categories and counts make sense, especially if the source contains inconsistent labels or empty cells.
In current Excel for Mac, look under Insert > Statistical for the Pareto chart option; names and placement can vary slightly between releases. Excel for the web may not expose the same statistical-chart creation controls as the Windows desktop app. If the command is unavailable, use the summary-table method below, or open the workbook in the desktop version.
Build one from a category-count table
For a controlled chart, set up three columns: category, count, and cumulative percentage. Sort the categories by count from largest to smallest before calculating the cumulative share. Sorting matters because the line should accumulate in the same order as the bars.
For example, suppose a quality report has five categories: Scratches, 40; Missing parts, 25; Wrong label, 15; Late delivery, 12; and Other, 8. The total is 100 observations. The cumulative percentages in that descending order are 40%, 65%, 80%, 92%, and 100%.
With category names in A2:A6, counts in B2:B6, and the table sorted from largest count to smallest, enter this in C2 and fill it down through C6:
=SUM($B$2:B2)/SUM($B$2:$B$6)
The formula returns 40% in C2, then 65%, 80%, 92%, and 100% as it is copied down. Format column C as Percentage. The expanding first range adds counts from the first row through the current row, while the fixed denominator keeps the total range constant. If your table has more or fewer categories, adjust the cell references to match.
- Select the category, count, and cumulative-percentage columns, including their headers.
- Choose Insert > Combo > Create Custom Combo Chart. Set the count series to Clustered Column and the cumulative-percentage series to Line.
- Enable Secondary Axis for the cumulative-percentage series, then create the chart.
- Format the secondary vertical axis as a percentage and, if appropriate, set its bounds from 0% to 100%. Check that the line rises to 100% at the final category.
The primary axis represents counts; the secondary axis represents cumulative percentage. Showing both on one scale can make the line misleading because counts and percentages are different measures. The secondary axis keeps the two series readable.
Read the bars and cumulative line
Start with the tallest bars to see the most frequent categories. Then follow the cumulative line to see how much of the total is covered by the leading categories. In the example, the first three categories account for 80 of 100 observations. That can help a team decide which issues to investigate first, but it does not prove that those causes are easiest or cheapest to fix.
Counts answer how often something happened, not how serious it was. If one rare defect has a major safety or customer impact, a frequency-only Pareto chart may push it to the far right even though it deserves immediate attention. Consider making a separate chart weighted by severity, cost, or delay when those measures better match the decision.
Keep the dataset and time window visible in the title or a note. Comparing charts from different periods can be misleading if the total number of observations changed substantially. For instance, a category’s count can rise while its share falls if the overall volume increased faster.
Format the chart for clear decisions
Use concise category labels and a descriptive title. If labels are long, widen the chart or rotate labels carefully rather than shrinking them until they are unreadable. A restrained color for the bars and a contrasting line color usually make the two measures easier to distinguish. Add data labels only when they improve readability; labeling every bar and every point can clutter a chart with many categories.
For a manual chart, check that the categories remain in descending count order after any data refresh or edit. A normal worksheet sort can change the order, but the cumulative-percentage values must still correspond to that order. If you add a new category, extend the total range in the formula and include the new row in the chart source.
When the chart has many low-frequency categories, consider grouping genuinely related, minor categories into Other. Do this transparently: keep the original detail available and state what was grouped. Do not combine unrelated causes simply to make the chart look simpler, because the result could hide a useful pattern.
Common problems and how to fix them
- The Pareto command is unavailable: Check that you are using a desktop Excel version with statistical charts, and that you selected a suitable range. If the command is not offered in your build or platform, prepare a count table and use the combo-chart approach.
- The same cause appears more than once: Standardize category text before charting. Extra spaces, spelling variations, and inconsistent capitalization can split one real category into several labels.
- The cumulative line does not end at 100%: In a manual chart, verify that all count rows are included in both the cumulative calculation and the total, and that the percentage series uses the same sorted rows as the bars.
- The bars are not in descending order: Sort the summary table by count, largest to smallest. With the built-in raw-record chart, Excel handles the frequency ranking; with a manual chart, the worksheet order determines the plotted sequence.
- The line appears flat or hard to read: Confirm that the line is plotted on the secondary axis and that the values are percentages rather than whole-number counts. Set the secondary axis to a sensible percentage scale.
- The chart changes when the source changes: Check the chart’s selected data range. A manually created chart may not include newly appended rows unless the source is expanded or maintained as an Excel table.
Built-in chart or custom combo chart?
The built-in Pareto chart is convenient when you have raw category observations and want Excel to count and rank them. It reduces setup work, but offers less direct control over how the data is summarized. A custom combo chart is better when the counts are already calculated, when you need to control category grouping, or when you want to audit every step in the worksheet.
A plain sorted bar chart can be enough if the goal is only to compare category counts. Use the Pareto format when cumulative contribution is relevant to the decision. Conversely, avoid adding the cumulative line just because the chart type is available; if the audience only needs a simple comparison, the extra axis may distract rather than help.
Frequently Asked Questions
Can Excel make a Pareto chart automatically?
Yes. In the desktop Windows version, select raw category records and choose Insert > Insert Statistic Chart > Pareto. Excel counts and ranks the categories and adds a cumulative-percentage line. For an existing count table, a custom combo chart is generally the more suitable route.
Can I create a Pareto chart from summarized data?
Yes. Sort the category-count table from largest count to smallest, calculate the running cumulative percentage, and create a combo chart with columns for counts and a line on the secondary axis for cumulative percentage.
Does a Pareto chart always follow the 80/20 rule?
No. The 80/20 phrase is a general principle, not a required chart pattern. Your data may show that a few categories dominate, or that many categories contribute similar amounts. Interpret the actual percentages rather than expecting a particular split.
Why is my cumulative percentage greater than 100%?
In a manual chart, the denominator may be too small, the same records may be counted twice, or the formula may include the wrong rows. Check that the numerator accumulates each count once and the denominator includes the full set of counts represented in the chart.
Can a Pareto chart show cost or severity instead of frequency?
Yes, if your category values are consistently summarized by that measure. A cost-weighted chart ranks causes by total cost, for example, rather than by number of occurrences. Label the measure clearly so readers do not mistake it for a frequency chart.
Related
- Budget Template in Microsoft Excel: Find and Use One
- Bps Number Format in Excel: Display Basis Points
- Bottom Border Excel Shortcut and How to Use It
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Google Sheets Chart Trendlines: Add and Customize OneTo add a trendline in Google Sheets, open the chart editor by double-clicking your chart, choose Customize >…
- Google Sheets Chart Templates: How to Find and Use ThemGoogle Sheets does not have a dedicated gallery of reusable chart-style templates, but you can start with a…
- Excel Pareto Chart Template: Build One Step by StepYes. In Excel for Microsoft 365 on Windows, a reusable Pareto chart template can be made from a…
- How to Format a Doughnut Chart in Excel for ClarityTo format a doughnut chart in Excel, select the chart and use the Chart Design tab to change…
- Excel 100% Stacked Lines in a Combo ChartYes, you can combine percentage lines with another chart type in Excel, but the most dependable method is…
- Excel: Remove Zero Values From a Stacked Bar ChartTo remove visible zero labels from an Excel stacked bar chart, format the data labels with a number…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.