Stacked Bar Chart in Excel: How to Add and Format One

Charts & pivot tables · Updated November 19, 2026

To add a stacked bar chart in Excel for Microsoft 365 on Windows, select a table with category labels and one or more data series, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. The chart places each series in a segment of a horizontal bar, letting you compare both category totals and the parts that make up each total.

What a stacked bar chart shows

A stacked bar chart uses one horizontal bar for each category. The bar is divided into colored segments, with each segment representing a value from a different data series. For example, a regional sales chart could show one bar per region, with segments for product lines. The full length of a bar represents that region’s combined sales, while its segments show how those sales are distributed.

This format is useful when the categories have a small number of meaningful components and you want to see totals and composition together. It is also helpful when category names are long: horizontal bars give labels more room than vertical columns. However, only the first series starts at the same baseline in every bar. Comparing the size of segments farther along the stack can therefore be harder, because their starting positions vary. If comparing individual series precisely is the main goal, a clustered bar chart may be easier to read.

Excel offers a standard Stacked Bar chart and a 100% Stacked Bar chart. The standard version preserves the values and total lengths. The 100% version rescales each category to 100%, so it emphasizes proportions rather than the original totals.

Arrange the data before inserting the chart

Excel works best when the source is a simple rectangular table. Put category names in the first column, series names in the first row, and numeric values in the cells where each category and series meet. For example, a table might have Region, Product A, Product B, and Product C as column headings, followed by one row for each region. Excel will usually interpret the first column as the bar categories and each remaining column as a separate series.

Keep the table’s labels clear and consistent. Avoid blank rows or columns inside the data, merged cells, and extra total rows unless you specifically want those rows charted. A grand-total row is often misleading in a stacked chart because it becomes another category made up of already-summed values. If the source contains a title above the table, leave that title outside the selected data range or make sure Excel does not mistake it for a data label.

  • Use one row per category, such as a region, month, or department.
  • Use one numeric column per component you want to stack.
  • Use text headings for the category and series names.
  • Check that values intended for comparison use the same unit, such as dollars throughout or units sold throughout.

For instance, a monthly expense chart could use months as categories and Rent, Utilities, and Supplies as series. Each bar would show total expenses for a month, divided into those three components. If some months have missing data, decide whether a blank means zero, unknown, or not applicable; those meanings are not interchangeable when interpreting the chart.

Create a stacked bar chart in Excel

With the data arranged in a table, create the chart from the Insert tab. If the data range is contiguous, click any cell in it and Excel will generally detect the whole table. To avoid including unrelated cells, select only the intended headings and values first.

  1. Select the category labels, series headings, and values.
  2. Choose Insert > Insert Column or Bar Chart.
  3. Under 2-D Bar, choose Stacked Bar. Choose 100% Stacked Bar only when you want to compare each category’s percentage mix rather than its total size.
  4. Review the result. Confirm that the category names appear on the vertical axis and the series appear as colored segments.
  5. Use Chart Design > Add Chart Element to add a chart title, axis titles, data labels, or a legend when they help explain the chart.

The exact chart gallery may look slightly different depending on the Excel window size, but the chart type is still in the Insert tab’s column-or-bar chart options. Excel for Mac has a similar workflow: select the data, use the Insert tab’s chart controls, and choose a stacked bar chart. The labels or gallery layout can differ slightly from Windows. Excel for the web also supports inserting charts, though some detailed formatting controls may be more limited than in the desktop application.

Choose between stacked, 100% stacked, and clustered

Use a standard stacked bar when the actual totals matter as well as the breakdown. If one department spends $80,000 and another spends $40,000, their bar lengths should communicate that difference. Segments within each bar show where the amounts came from.

Use a 100% stacked bar when the relative shares matter more than the total. In that chart, every bar has the same overall length. A department spending $40,000 can look as long as one spending $80,000; the chart compares the percentage composition, not the amount. This is a frequent source of confusion, so label the chart or its axis to make the percentage basis clear.

A clustered bar chart places the series side by side within each category instead of stacking them. It is often preferable when readers need to compare the same series across categories, because the bars share a common starting point. The trade-off is that totals are less visually immediate. As a practical guide:

  • Choose stacked bars to show totals and component contributions.
  • Choose 100% stacked bars to compare proportions across categories with different totals.
  • Choose clustered bars to compare individual series values directly.

Format labels, colors, and axes for readability

A useful chart should explain itself without forcing readers to guess what the colors or scale mean. Select the chart, then use Chart Design > Add Chart Element to add a title, axis titles, and data labels. A descriptive title such as Monthly expenses by category is more informative than a generic label such as Chart Title. Keep the legend if the series names are not otherwise clear.

Data labels can show the values inside or beside the segments, but labeling every segment may clutter a chart with many categories or small values. Try labels when there are only a few series and categories. If labels overlap or appear crowded, remove them or show fewer labels, and let the axis and legend carry the information. In a 100% stacked chart, make sure readers understand whether labels show percentages or underlying values; check the chart’s label options and the result rather than assuming the displayed format.

Use a consistent, distinct color for each series. Avoid colors that are too similar, and consider whether the chart remains understandable for readers with color-vision differences. The chart’s colors can be changed by selecting a series and using the Format Data Series controls, or by choosing a different option under Chart Design > Change Colors. A restrained palette usually makes the comparison easier than assigning a bright color to every item.

Category order is another detail worth checking. Excel may display the first category at the bottom of a horizontal bar chart. If you want the first table entry at the top, right-click the category axis, choose Format Axis, and look under Axis Options for Categories in reverse order. Excel can reposition the value axis after the order changes; if that makes the layout awkward, review the axis-crossing options in the same pane.

Read totals and components carefully

In a standard stacked bar chart, the endpoint of each complete bar represents the total of its component values. The axis usually begins at zero, which preserves a fair visual relationship between lengths and values. If the chart has a horizontal value axis, check its scale and number format so readers can distinguish, for example, thousands of dollars from individual dollars.

Segments after the first are harder to compare accurately across categories because they do not share a common baseline. A blue segment that begins after a green segment in one bar may start at a different horizontal position in another. This is why stacked bars are better for seeing overall composition than for making precise comparisons of every component. If you need both a strong total comparison and exact component comparisons, consider using a separate chart or a table alongside the stacked chart rather than trying to force one graphic to do everything.

Also distinguish totals from percentages. A standard stacked bar shows the source values and makes bars of different total lengths. A 100% stacked bar gives every category an equal total length and shows each component’s share of its category. Neither is inherently better: the right choice depends on whether absolute size or composition answers the question.

Fix common stacked bar chart problems

If Excel creates bars for the series when you expected bars for the categories, the rows and columns may be interpreted in the opposite direction. Select the chart and choose Chart Design > Switch Row/Column. This changes how Excel groups the existing data; it does not alter the worksheet table. If the result still looks wrong, use Chart Design > Select Data to inspect the chart data range, series names, and category labels.

If the chart includes headings, totals, or blank categories you did not intend, choose Chart Design > Select Data and correct the data range, or reselect the intended source data and insert the chart again. Check for text values in numeric columns: a number stored as text may not be plotted as expected. Similarly, a blank cell is not automatically the same as a zero. Use a zero only when the value genuinely represents none; do not replace unknown information with zero just to make the bars look complete.

If labels or the legend are missing, select the chart and use Chart Design > Add Chart Element to add the needed element. If a series is absent, inspect Select Data to see whether its column was included. If values are technically present but the chart looks compressed, check for an unusually large value or an unintended total in the source range. One large category can make the other bars appear tiny on a shared scale.

Update and share the chart

A chart based on an ordinary cell range usually reflects changes made within that range, but it may not automatically include new rows added below the original selection. Converting the source data to an Excel table with Insert > Table is a useful way to manage expanding lists; charts based on table data can include added table rows as the table grows. Confirm the chart after adding records, especially if the workbook has been edited or the chart’s source range was set manually.

For a report, keep the chart near the table or notes that explain its units and scope. A concise title, clear category names, and a visible legend often matter more than decorative effects. When sharing the workbook, make sure the recipient can see the source data or understands where the chart’s numbers came from. If exporting or copying the chart into another document, inspect the pasted version for clipped labels and reduced text size.

Frequently Asked Questions

How do I add a stacked bar chart in Excel?
Select the category labels, series headings, and values, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Check that Excel has assigned categories and series in the intended direction.

What is the difference between a stacked bar and a 100% stacked bar?
A standard stacked bar preserves original values and shows totals through bar length. A 100% stacked bar makes every category the same total length and shows each component’s percentage share.

Can I change which data series appear in the chart?
Yes. Select the chart and choose Chart Design > Select Data. You can adjust the chart data range and edit, add, or remove series. Use Switch Row/Column if Excel has grouped the data in the wrong direction.

How do I put the first category at the top?
Right-click the category axis, choose Format Axis, and enable Categories in reverse order under Axis Options. Check the value-axis position afterward because Excel may move it when the category order changes.

When should I use a stacked bar instead of a clustered bar?
Use a stacked bar when you want to show category totals and their component makeup. Use a clustered bar when direct comparison of individual series across categories is more important than showing totals.

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.