Stacked Pareto Chart in Excel: How to Build One

Charts & pivot tables · Updated November 20, 2026

Excel does not have a built-in chart type called a stacked Pareto chart. To make one in Microsoft 365 for Windows, sort categories by their combined total, chart their component values as stacked columns, then add a cumulative-percentage line on a secondary axis.

What a stacked Pareto chart shows

A Pareto chart helps identify which categories account for the largest share of a total. A conventional Pareto chart uses bars ordered from largest to smallest and a line showing the running cumulative percentage. It is based on the idea that a relatively small number of causes may account for a large portion of a problem, although the familiar 80/20 ratio is a guideline, not a rule.

A stacked version keeps the same descending category order and cumulative line, but divides each bar into segments. For example, a returns team could compare return reasons while splitting each reason by warehouse versus carrier responsibility. The full height of each bar represents the category total; the colored segments show how that total is divided.

The distinction matters: Excel’s built-in Pareto chart is a statistical histogram chart, not a stacked-column Pareto chart. For stacked segments, create a regular chart and configure its series yourself. The cumulative line should be calculated from the complete category totals, not separately within each segment.

Arrange and sort the source data

Use one row per category and one numeric column for each component you want to stack. Add a total column so the categories can be ranked, and a cumulative-percentage column for the line. For instance, a returns report could use this layout:

  • Column A: return reason
  • Columns B and C: warehouse cases and carrier cases
  • Column D: combined cases
  • Column E: cumulative percentage of all cases

Enter the categories and component counts, calculate the totals, and sort the whole table by the total column from largest to smallest. Keep each category’s component values together when sorting. The cumulative percentage must follow this sorted order; sorting after calculating it changes what the line means.

Here is a small example, already in descending order: Late delivery has 12 warehouse and 18 carrier cases, for 30 total; Damaged has 4 and 14, for 18; Wrong item has 10 and 2, for 12; Missing parts has 6 and 4, for 10. The grand total is 70. This example makes the stacked segments visible while keeping the Pareto ranking based on the full number of cases.

Calculate totals and the cumulative line

With category names in A2:A5 and component counts in B2:C5, enter this in D2 to total the first category, then fill it down through D5: =SUM(B2:C2). The totals are 30, 18, 12, and 10, adding to 70. If your table has more component columns, expand the SUM range to include them.

With category totals in D2:D5, enter this in E2 and fill it down through E5: =SUM($D$2:D2)/SUM($D$2:$D$5). The dollar signs keep the grand-total range fixed while the running range expands as the formula is filled down. Format E2:E5 as Percentage. The example returns approximately 42.86%, 68.57%, 85.71%, and 100%.

Check the final line value: it should reach 100% if every category is included and the total is nonzero. If the data includes filtered-out or excluded categories, decide whether the denominator should include them; a Pareto line normally expresses the running share of the population represented by the chart.

Create the stacked columns and percentage line

In Excel for Microsoft 365 on Windows, select the category names in A1:A5 and the component series in B1:C5, including their headers. Insert a stacked column chart using Insert > Insert Column or Bar Chart > 2-D Stacked Column. Depending on the ribbon layout, the chart command may appear under Insert > Charts.

Next, add the cumulative-percentage series. Select the chart, then use Chart Design > Select Data and add a series with E1 as its series name and E2:E5 as its values. Set the category axis labels to A2:A5 if Excel has not assigned them already. Do not add column D, the totals, as another column series: the component columns already sum to those totals, so including D would double-count the bars.

With the chart selected, choose Chart Design > Change Chart Type, then select Combo. Set each component series to Stacked Column and the cumulative-percentage series to Line. Select Secondary Axis for the cumulative line, then confirm. Excel’s combo-chart dialog may list the series in a table; check each series’ chart type rather than assuming Excel chose the intended combination.

On current desktop versions of Excel for Mac, combo charts and secondary axes are also available, although the ribbon arrangement and dialog labels can differ; use Insert > Chart or Chart Design > Change Chart Type to find the Combo options. Excel for the web has a more limited chart-editing interface. If it does not expose the combo or axis controls you need, open the workbook in desktop Excel.

Format axes, labels, and the legend

The left vertical axis measures cases, while the right vertical axis measures cumulative share. Select the right axis and open Format Axis. Set its minimum to 0 and maximum to 1 when the percentages are stored as decimal fractions, then set its number format to Percentage. A maximum of 1 corresponds to 100%; setting it to 100 when the values are fractions would leave the line almost flat.

Use a clear chart title, such as Returns by Reason and Cumulative Share. Give each component a distinct, accessible color and keep the cumulative line visually different from the columns. If the line is hidden behind the bars, use a contrasting line color and increase its width. Add markers if they make the cumulative value at each category easier to read.

Data labels can help, but labeling every segment, total, and line point may clutter a chart with many categories. Consider labeling the line percentages or the largest bars, and keep the legend names concise. If readers need exact totals, place the total column in a nearby table rather than adding it as another plotted series.

Read the chart without misreading it

Each stacked bar’s total height is the combined size of a category. Its segments show how the components contribute to that total. The cumulative line answers a different question: what share of all cases is covered by the categories up to this point in the descending ranking? In the example, Late delivery accounts for 30 of 70 cases, or 42.86%; Late delivery plus Damaged accounts for 48 of 70, or 68.57%.

Do not interpret the line as the cumulative share of each individual colored component. It is calculated from the sum of all components in each category. If the goal is to find which component drives the problem overall, create a separate analysis ranked by component totals or use a chart designed for that comparison.

Also, a category crossing 80% does not prove that the remaining categories are unimportant. The cutoff is a practical way to focus investigation, not a statistical guarantee or a reason to ignore low-frequency but serious issues. Use the chart to prioritize questions, then check the operational impact and context of each cause.

When a stacked Pareto is useful—and when it is not

A stacked Pareto is useful when both the ranking of whole categories and the makeup of each category matter. Examples include complaint types split by product line, defects split by production shift, or service incidents split by region. The stack can reveal whether a high-ranking category is driven mostly by one component or shared across several.

However, stacked segments are harder to compare precisely than separate bars, especially for segments that do not share a common baseline. If comparing the same component across categories is the main task, a clustered column chart, a sorted component-level Pareto, or a small-multiple chart may be clearer. If there are many components or categories, the stacked chart can become too dense to read.

Choose a stacked Pareto when the category total and its composition are both important. Choose a conventional Pareto when the main question is simply which categories contribute most. Choose a 100% stacked chart when composition percentages matter more than absolute size, but note that it changes the column heights to equal lengths and is not the same as a standard Pareto bar chart.

Common problems and fixes

  • The columns are not in Pareto order: Sort the source rows by the combined total in descending order. Make sure the component values and category names move with each row.
  • The cumulative line looks flat: Confirm that it uses the secondary axis and that the axis maximum matches the data scale. Decimal percentages usually run from 0 to 1.
  • The line ends above or below 100%: Check that the formula’s final running range includes every plotted category and that its denominator matches the intended population.
  • The bars are too tall: Remove the total series from the stacked columns. Plot only the component series; their combined height is already the total.
  • The line is missing or appears as columns: Open Change Chart Type > Combo and explicitly assign the cumulative series to Line and Secondary Axis.
  • Categories appear in the wrong order: Verify the horizontal-axis labels point to the sorted category cells, not to an unsorted range or the series headers.

Frequently Asked Questions

Can Excel make a stacked Pareto chart automatically?
Not as a single built-in chart type. Excel’s built-in Pareto chart is a histogram. For stacked bars with a cumulative line, build a combo chart using stacked columns and a line on a secondary axis.

Should I sort by the total or by each stack segment?
Sort categories by their combined total. That makes the full stacked bar heights descend from largest to smallest, which is the defining order for this Pareto-style view.

Why does my cumulative percentage line not reach 100%?
Check whether the final cumulative formula includes all plotted rows and whether the denominator includes exactly the same set of records. Also make sure the final category is included in the chart’s data range.

Can the cumulative line use the same axis as the columns?
It can, but usually should not. Case counts and percentages use different scales, so putting both on one axis can make the line difficult to interpret. A secondary percentage axis makes the units explicit.

Is a stacked Pareto better than a regular Pareto chart?
Only when the composition of each category is relevant. A regular Pareto chart is simpler for ranking causes; stacked segments add detail but can make comparisons harder, particularly with many categories or components.

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.