How to Make a Stacked Bar Chart in Excel

Charts & pivot tables · Updated November 20, 2026

To make a stacked bar chart in Excel for Microsoft 365 on Windows, arrange categories in the first column and each part of the total in its own adjacent column, select the whole table including headers, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Excel creates one horizontal bar per category, with each series shown as a segment; use Stacked Column instead if you want vertical bars.

What a stacked bar chart shows

A stacked bar chart compares totals across categories while also showing how each total is divided among its component series. For example, a shop could compare monthly sales across regions, with one segment for each product type. The full length of a bar represents the month’s total sales, and the segment lengths show the contributions from the product types.

This design is useful when both the total and the composition matter. It can show, at a glance, that one category has a larger overall result, or that one component makes up a larger share of a particular total. It is not equally good at every comparison, though: only the first segment in each bar starts at the same baseline. Segments farther along the bar have different starting points, so comparing their lengths precisely can be difficult.

Excel’s standard Stacked Bar chart uses the actual values. The 100% Stacked Bar chart instead scales each category to the same full length, making it easier to compare proportions when totals differ. That distinction matters: the 100% version hides differences in total size. A category with a small total and one with a large total will both fill the same width.

Prepare the worksheet data

Set up the source data as a simple rectangular table. Put the category labels down the first column, and give each component its own column with a clear header. For instance, a quarterly report might have a Quarter column followed by Online, Store, and Wholesale columns. Each row then contains the values for one quarter.

  • Use one header row, with a distinct name for every series.
  • Keep one category per row and one series per column for the easiest setup.
  • Enter numeric values consistently. Avoid mixing numbers with text such as currency symbols typed directly into cells.
  • Do not include grand-total rows or columns in the selected range unless you deliberately want them charted as another category or series.
  • Keep the table contiguous, without blank rows or columns breaking up the data.

Excel can interpret a chart’s orientation in different ways, but this layout usually produces the intended result immediately. If your existing report has series down the rows and categories across columns, you can still chart it and use Switch Row/Column afterward. Before inserting the chart, check that the headers describe the values and that there are no accidental text entries in numeric cells. A value stored as text may be ignored or plotted unexpectedly.

Create the chart step by step

  1. Select the complete data range, including the header row and category labels. If the range is an Excel table, clicking a cell in the table may be enough to select its data for charting.
  2. Open the Insert tab on the ribbon.
  3. Choose Insert Column or Bar Chart in the Charts group, then select 2-D Bar > Stacked Bar. Choose 100% Stacked Bar if your goal is to compare shares rather than actual totals.
  4. Check the result. The category names should appear along the vertical axis, and the series names should identify the segments in the legend.
  5. Click the chart title to replace it with a specific description, such as Monthly sales by channel.

In Excel for Mac, the chart choices are also on the Insert tab, though ribbon spacing and menu presentation can vary by release. Excel for the web offers chart insertion too, but some detailed formatting controls may be more limited or located differently than in the desktop app. If you do not see the exact named button, look in the Insert tab’s chart options for the 2-D Bar chart gallery and select the stacked type.

Choose between stacked, 100% stacked, and clustered

Use a standard Stacked Bar chart when the size of the total is meaningful and readers should see it. If values are units sold, hours worked, or dollars by component, this view preserves their magnitude. A 100% Stacked Bar chart is better for composition: it compares the fraction each component contributes, even when category totals vary.

A Clustered Bar chart is often clearer when the main question is how the same series compares across categories. In a stacked chart, only the first series shares a common starting position. In a clustered chart, the series are placed side by side, so readers can compare individual values more directly, although the chart takes more space and no longer emphasizes the combined total as strongly.

Choose a 100% chart carefully if the actual totals are important to the audience. One practical option is to use a 100% chart to emphasize mix and include the total in a nearby table, a subtitle, or a separate summary. Conversely, if the point is to compare totals, do not select 100% Stacked just because all the bars look neatly aligned.

Format labels, colors, and order

Make the chart readable before adding decoration. Select the chart and use the Chart Design tab to add or adjust chart elements, including the chart title, axis titles, legend, and data labels. The plus-shaped Chart Elements button beside a selected chart may also provide quick access to common elements. Exact controls can vary slightly with the Excel build and chart selection.

Data labels can help readers identify segment values without estimating from the axis. To add them, select the chart, then use Chart Design > Add Chart Element > Data Labels and choose a position. Labels may crowd small segments, so it is often better to label only when the chart has a modest number of categories and series. You can also select individual labels or a series to format them, and use number formatting that matches the data, such as whole numbers or currency.

Use a distinct, consistent color for each series, not a different color for every category. Select a series and use the Format Data Series options to change its fill. A restrained palette helps the legend remain useful; very similar colors make adjacent segments hard to distinguish. Avoid relying on color alone when the chart will be printed in grayscale or viewed by people with color-vision differences. Direct labels or a clear legend can provide another cue.

If the categories or series appear in an inconvenient order, select the chart and choose Chart Design > Select Data. The Select Data Source dialog lets you change the chart’s data range, edit series, and use Switch Row/Column. To reorder series, select a series in the Legend Entries (Series) list and use the move controls. For horizontal bar charts, category order may also be affected by the vertical axis settings; if the first category appears at the bottom rather than the top, right-click that axis, choose Format Axis, and check the category-order options.

Understand totals and axis scaling

In a standard stacked chart, the end of each bar represents the sum of its component values. A segment’s width represents that series’ value, while the bar’s full width represents the category total. This means the chart can show both, but the axis scale must make sense for the data. If totals vary widely, small bars may be difficult to inspect; labeling the totals or providing a companion table can help.

Excel does not necessarily display the total as a separate data label just because the chart is stacked. Data labels typically label plotted points or series values, not a computed sum of all segments. If readers need the total printed at the end of each bar, you can add a total column to the source data for reference, but including that column as another plotted series would count it again and make the chart misleading. Instead, consider creating labels from a carefully prepared helper range if your Excel version and chart-label workflow support it, or place totals in adjacent cells or a data table. Verify any labels against the source values.

Negative values need special care. Excel can plot positive and negative contributions on opposite sides of the zero point, which changes the visual meaning from a single left-to-right total. If the chart mixes signs, explain the baseline and confirm that the resulting bars answer the question you intend to ask. For many mixed-sign datasets, a different chart type or a separate view for positive and negative values is clearer.

Fix common chart problems

  • The chart has the wrong orientation: Use Chart Design > Switch Row/Column. If that does not solve it, check that the headers and category labels are in the expected row and column.
  • Excel plots a total as a segment: Remove the total row or column from the chart’s source range. A total plotted alongside its component values double-counts the information.
  • The labels or legend show generic names: Check that the selected range includes the header row. In Chart Design > Select Data, edit the series name or category-label range if needed.
  • The bars look reversed: Change the order of the source categories or adjust the vertical category axis settings through Format Axis. Reversing the category axis can also affect where the horizontal axis crosses.
  • Some segments are missing: Check for blank cells, text-formatted numbers, filtered rows, and an incomplete chart data range. Confirm that the values are included in the selected range.
  • Labels overlap or are too small: Reduce the number of series, enlarge the chart, remove labels from tiny segments, or use a companion table. More labels do not always make a chart easier to read.

When data will grow over time, converting the source range to an Excel table with Insert > Table can make it easier to maintain. Charts based on a table can generally expand as new rows are added, but check the chart after extending the data, especially if new series or unusual blank rows are involved. If you have already made a chart, use Chart Design > Select Data to confirm its source range rather than assuming Excel included every new entry.

When another chart is a better choice

A stacked bar is a poor choice when there are many series, when most segments are tiny, or when the audience must compare every component precisely. A long legend and a row of narrow colored slivers can obscure the information. A clustered bar may be better for comparing component values side by side; a line chart may be more appropriate for showing change over time; and a table may be the clearest option when exact figures matter more than visual patterns.

Consider the number of categories as well. Horizontal bars work well with long category names because there is more room to read them than beneath vertical columns. If there are dozens of categories, sorting them by a useful measure or showing a focused subset can improve readability. Avoid sorting categories in a way that implies a time sequence if their order is not chronological.

Frequently Asked Questions

How do I make a 100% stacked bar chart in Excel?
Select the data, then choose Insert > Insert Column or Bar Chart > 2-D Bar > 100% Stacked Bar. Excel scales each category to 100%, so compare the segment proportions rather than the original totals.

What is the difference between a stacked bar and a stacked column chart?
A stacked bar chart displays horizontal bars, while a stacked column chart displays vertical columns. Both divide each category’s total into series segments; horizontal bars often suit long category labels.

How do I change the order of the segments?
Select the chart and choose Chart Design > Select Data. In Legend Entries (Series), select a series and use the move controls to change its position. The segment order in the stack and the legend order follow the series arrangement.

Can I show the total at the end of each stacked bar?
Excel does not automatically add a sum label merely because a chart is stacked. Do not plot the total as an additional series, since that would duplicate the components. Use a separate total label or adjacent table and check each displayed total against the data.

Why are my categories in the wrong order?
Check the source row order first. For a horizontal bar chart, the vertical category axis can display categories in the reverse order; right-click the axis, choose Format Axis, and adjust its category-order setting if needed.

Can I make a stacked bar chart in Excel for the web?
Yes. Excel for the web supports inserting charts, including stacked bar chart types. Some detailed formatting and data-label controls can differ from desktop Excel, so open the workbook in the Windows or Mac app if a needed control is unavailable.

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.