Excel Stacked Horizontal Bar Chart: Setup and Tips

Charts & pivot tables · Updated November 19, 2026

To make a stacked horizontal bar chart in Excel for Microsoft 365 on Windows, arrange each category in a row and each data series in its own column, select the table, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. The chart shows each category as a horizontal bar divided into colored segments, so you can compare both the total and the series that make it up.

What a stacked horizontal bar chart shows

A stacked bar chart places categories on the vertical axis and values on the horizontal axis. Each bar is assembled from segments, one for each series in your source data. For example, a retailer could compare monthly sales by product line: each month gets one bar, and the colored segments show the contribution from each product line. The overall bar length represents the combined value for that month.

This chart is useful when the categories have meaningful totals and you want to see how those totals are composed. It can make it easier to compare a small set of categories than a stacked column chart, especially when category names are long. Because bars share a baseline, readers can compare the first segment across categories readily. Segments farther along the bar are harder to compare precisely because their starting positions differ.

A standard stacked bar chart uses the original values, so a longer bar means a larger total. A 100% stacked bar chart instead scales every category to 100%. It emphasizes percentage composition, not differences in total size. These chart types answer related but distinct questions; choosing between them changes what the graphic communicates.

Prepare the worksheet data

Put the category labels in the first column and the series names across the top row. Keep one row per category and one column per series, with numeric values in the cells where they intersect. For example:

Month Hardware Software Services
January 42 28 15
February 35 33 19
March 48 25 22

With this layout, each month becomes a bar and each product line becomes a segment. January totals 85, February totals 87, and March totals 95. Include clear headers, avoid blank rows or columns inside the data, and make sure values are numbers rather than text that merely looks numeric. A title row above the table is fine, but do not include it in the selected range unless you intend it to be chart data.

  • Use consistent units across all series, such as dollars, units sold, or hours.
  • Decide how blank cells should be handled. A blank may be treated differently from a recorded zero, so enter zero when it means the series contributed nothing.
  • Keep totals out of the plotted range unless they are meant to be an additional series; otherwise, Excel may stack the total on top of its components and misrepresent the result.

Create the chart in Excel

  1. Select the category labels, series headings, and data values, including the header row and label column.
  2. Choose Insert > Insert Column or Bar Chart.
  3. In the 2-D Bar group, choose Stacked Bar. Do not select Clustered Bar, which places series beside one another rather than stacking them.
  4. Check that each bar represents a category and that the legend lists the data series. If Excel interpreted rows and columns the other way around, select the chart and choose Chart Design > Switch Row/Column.

When the chart is selected, Excel displays chart-specific tabs, including Chart Design and Format. Use Chart Design > Add Chart Element to add items such as a chart title, axis titles, data labels, or a legend. In current Microsoft 365 desktop Excel for Mac, the chart concepts and commands are similar, though their placement can vary with the ribbon layout. Excel for the web supports creating and editing charts, but some detailed formatting controls available in desktop Excel may be limited or presented differently.

For a table that will grow over time, consider converting the source range to an Excel table with Insert > Table before creating the chart. Charts based on a table can include newly added rows as the table expands, reducing the need to adjust the chart’s source range manually. Check the chart after adding data to confirm that the new categories and values appear as intended.

Format the bars, labels, and axes

Formatting should make the values easier to compare, not decorate the chart at their expense. Give each series a distinct, consistent color and use a useful chart title, such as Monthly sales by product line. If the chart needs units, label the horizontal value axis. Keep the legend close enough to the chart that readers can associate colors with series.

To change the space between category bars, right-click a bar and choose Format Data Series. In the formatting pane, adjust Gap Width. A smaller gap makes the bars thicker; a larger gap separates categories more. Since the bars are stacked, changing gap width does not separate the segments within a bar. Use the same series colors across related charts so a color keeps the same meaning.

Data labels can show values on the segments. Select the chart, then use Chart Design > Add Chart Element > Data Labels and choose a position. Labels are most useful when there are few segments and enough room to read them. With many categories or narrow segments, labels may overlap or become cramped. You can label only the most important values, increase the chart size, or rely on the axis and legend instead. If you need the total as well as segment values, Excel does not automatically add a grand-total label to every stacked bar in all chart setups; a separate total series or carefully positioned labels may require additional work, so verify the display rather than assuming the segments include a total label.

Excel commonly displays the first category at the bottom of a horizontal bar chart, which can surprise people expecting it at the top. To change the order, right-click the category axis, choose Format Axis, and under Axis Options select Categories in reverse order. Check the position of the value axis afterward; changing category order can alter where the axes cross. The series order also matters: the first series is closest to the baseline, and later series build outward. To alter it, use Chart Design > Select Data and move series up or down in the Legend Entries (Series) list.

Choose between stacked, 100% stacked, and clustered bars

Use a standard stacked bar when both the category totals and the composition matter. In the sales example, it shows that March has the largest total while also showing how much each product line contributes. It is less suitable when the main task is comparing every product line with precision: only the first segment starts at a common zero point, while later segments start at different values.

Choose 100% Stacked Bar when the question is about share of each category rather than the absolute amount. Select the data and choose Insert > Insert Column or Bar Chart > 2-D Bar > 100% Stacked Bar. All bars become the same length, and the horizontal axis represents percentages. In the example, this makes it easier to compare whether Services accounts for a larger share in March than in January, but it hides the fact that March’s total is larger.

Choose Clustered Bar when the priority is comparing individual series values side by side across categories. For instance, it is often easier to compare Hardware sales between months in a clustered chart because all Hardware bars start at zero. The trade-off is that the chart no longer presents one continuous bar for each category total. The right choice depends on the comparison the reader needs to make, not simply on which design looks more compact.

Handle dates, missing values, and negative numbers

Category labels can be months, departments, products, or other groups. Excel may treat date-like labels as dates, so check that the intended order is preserved. If categories are out of order, sort the source data in the desired sequence or use the category-axis settings. The chart normally follows the order of rows in the source range; it does not automatically sort categories by the size of their totals.

Negative numbers are valid, but they change the visual interpretation. In a stacked bar chart, positive and negative values extend on opposite sides of the zero line. This can be helpful for showing gains and losses or budget variances, but readers should be told what positive and negative mean. Avoid interpreting the full visible length as a simple positive total when the bar contains values on both sides of zero.

Missing observations deserve attention. A zero means a measured contribution of none, while a blank can mean not recorded, not applicable, or unknown. Those meanings are not interchangeable. Decide what the source data means, represent it consistently, and explain a missing-data convention if it could affect conclusions. If your series have different units, do not stack them as if they were directly additive; for example, dollars and customer counts do not make a meaningful combined total.

Common problems and practical fixes

  • The chart is clustered instead of stacked: choose Stacked Bar, not Clustered Bar, from the 2-D Bar chart menu. If changing an existing chart, use Chart Design > Change Chart Type and select the stacked option.
  • Series and categories are reversed: select the chart and choose Chart Design > Switch Row/Column. Then check the legend and category labels; a chart can look plausible even when it plots the wrong grouping.
  • Bars appear in an unexpected vertical order: right-click the category axis, open Format Axis, and change Categories in reverse order. Confirm the value-axis position afterward.
  • Some values are missing or oddly small: inspect the selected source range for omitted rows, text-formatted numbers, blanks, or an accidentally included total column. Use Chart Design > Select Data to review the chart range and series.
  • Labels overlap: remove nonessential labels, enlarge the chart, reduce the number of categories, or use a table alongside the chart. A label on every tiny segment is not always readable.
  • The colors are difficult to distinguish: use a restrained palette with clear contrast, and do not rely on color alone when the chart will be read in grayscale or by people with color-vision differences. Keep the legend and series order clear.

Frequently Asked Questions

How do I make a horizontal stacked bar chart in Excel?
Select a table with categories in rows and data series in columns, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. If the categories and series are swapped, use Chart Design > Switch Row/Column.

What is the difference between a stacked bar and a 100% stacked bar?
A standard stacked bar preserves the underlying values and lets total bar length vary. A 100% stacked bar scales every category to the same total, making percentage composition easier to compare while obscuring differences in absolute totals.

How do I put the first category at the top?
Right-click the vertical category axis, choose Format Axis, and select Categories in reverse order under Axis Options. Review the horizontal value axis afterward because the crossing position may change with the category order.

Can I show the total above each stacked bar?
Excel’s standard stacked-bar labels show series values, not necessarily the sum of all segments. You can calculate totals in an adjacent worksheet column and use them as labels through chart-label options in desktop Excel, or add labels manually, but verify alignment whenever the chart data changes. A separate total series should not simply be stacked with the components because that would double-count the visual total.

Can a stacked bar chart include negative values?
Yes. Positive and negative values extend in opposite directions from zero. This works for values such as gains and losses, but use a clear axis and explanation, and do not describe the full bar as a straightforward sum when positive and negative contributions are mixed.

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.