Creating a Stacked Bar Chart in Excel: Steps & Tips

Charts & pivot tables · Updated November 19, 2026

To create a stacked 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 data, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Excel creates a horizontal chart in which each bar shows a category’s total and its colored segments show the contribution of each series.

What a stacked bar chart shows

A stacked bar chart compares totals across categories while showing how each total is divided among component series. For example, a shop could compare monthly sales across four locations, with each month represented by one bar and each location represented by a differently colored segment. The full bar shows combined sales for that month; the segment lengths show each location’s contribution.

In Excel, a bar chart runs horizontally: categories appear along the vertical axis, and values extend along the horizontal axis. A stacked column chart uses the same stacking idea but displays the bars vertically. The two formats can represent the same data, so the choice is often about the chart’s shape and the length of the category labels.

Stacked bars are most useful when the total and its parts both matter. They are less effective for comparing individual series across many categories, because only the first segment shares a consistent starting point. Segments in the middle or at the end are harder to compare precisely.

Arrange the worksheet data

Set up a simple rectangular table with one header row. Put the category names in the first column and the series names across the top. Use one row per category and one numeric value per category-series combination. For instance, a table might have months in column A, North in column B, South in column C, and West in column D. Excel uses the month names as bar categories and the region headings as the legend entries.

Keep the table compact and avoid blank rows or columns inside it. Make sure the headings are descriptive, since Excel uses them to label the chart. Check that the values are numeric rather than text that merely looks like numbers; text values may be ignored or plotted unexpectedly. If the source data includes a totals column or totals row, leave it out of the chart selection unless you specifically want those totals plotted as another series or category.

Before selecting the range, decide what one bar should represent. If the goal is to compare departments within each quarter, put quarters in rows and departments in columns. If Excel builds the chart with departments as the bars instead, you can change the orientation later. A clear table structure makes that adjustment easier.

  • Use consistent units across all series, such as dollars for every value.
  • Use zero for a known absence of a contribution; leave a cell blank only when the value is genuinely missing or unknown.
  • Keep category names concise. Long labels can make a horizontal bar chart taller and harder to scan.

Create the stacked bar chart

  1. Select the category labels, series headings, and data values, including the header row and category column but excluding unrelated notes or totals.
  2. On the ribbon, choose Insert > Insert Column or Bar Chart.
  3. Under 2-D Bar, select Stacked Bar. Choose 100% Stacked Bar instead only when the intended comparison is the percentage composition of each category.
  4. Check that the categories, series, and legend appear in the intended roles. If they do not, select the chart and choose Chart Design > Switch Row/Column.

Excel inserts a chart based on the selected range. Click the chart title to replace the default wording with a specific description, such as “Quarterly sales by region.” A title that identifies the measure and time period is more useful than a generic label such as “Sales” when the chart might be viewed separately from its worksheet.

In Excel for Mac, the same basic process is available from the Insert tab’s chart controls; select a 2-D stacked bar chart. The chart-design controls may be arranged differently from the Windows ribbon. In Excel for the web, select the data and use the Insert tab’s chart options; some formatting controls may be more limited than in the desktop app.

Choose the right stacked chart type

Excel offers stacked bar and 100% stacked bar charts, as well as corresponding column versions. A standard stacked bar uses the actual values. If one category totals 120 and another totals 80, their bars have different lengths. This is the right choice when both overall totals and component amounts are meaningful.

A 100% stacked bar scales every category to the same full length. Its segments show each series as a share of that category’s total, so it is useful for comparing composition when categories have different totals. The chart no longer shows the size of those totals: two categories with very different amounts still fill the same width. If absolute volume matters, include the totals elsewhere or use a standard stacked chart instead.

Choose a horizontal bar rather than a vertical column when category labels are long, when there are many categories, or when a ranking is easier to read from top to bottom. A stacked column may suit a short list of categories or a time series where vertical bars are familiar. Changing the orientation does not change the data’s meaning, but it can affect label readability and how easily viewers compare values.

Format labels, colors, and axes

Make the chart easy to interpret before adding decoration. Use a clear title, retain a legend when the colors are not self-explanatory, and format the value axis to match the data. For example, a chart of currency values should use a currency or number format that is consistent with the source figures. Avoid excessive decimal places when they do not add meaningful precision.

To add labels, select the chart and use Chart Design > Add Chart Element > Data Labels, then choose a position. Labels can show the value within each segment, but a chart with many small segments may become crowded. If the labels collide or are too small to read, remove them and rely on the axis and legend, or label only the most important series. In some Excel layouts, the chart’s Chart Elements button (the plus sign beside the chart) also provides data-label controls.

Use colors that are clearly distinct, especially for adjacent segments. The legend order follows the series order in the source data; you can change that order by rearranging the source columns or adjusting the series in Select Data. Be careful with changing colors just to make the chart more attractive: keep the same series color across related charts so readers can recognize it consistently. Light gridlines can help estimate values, but too many lines compete with the bars.

If category labels appear in an unexpected order, check the source row order and the axis settings. Excel may display the first category at the bottom of a horizontal bar chart. If you want it at the top, right-click the category axis, choose Format Axis, and adjust the category-order setting. Review the result after changing the setting, since the value-axis crossing position may also move.

Understand totals, blanks, and missing values

In a standard stacked chart, the total length of each bar is the sum of its series values. That makes a separate total series unnecessary and usually harmful: including it stacks the total on top of its components, exaggerating the bar. Keep a totals column in the worksheet if it is useful for checking calculations, but exclude it from the chart’s data range.

Zeros and blanks communicate different things. A zero means the category has no contribution from that series, while a blank can mean that the value was not reported. Excel’s chart handling of empty cells can be adjusted: select the chart, open Chart Design > Select Data, then choose Hidden and Empty Cells. The available display choices depend on chart type; for a stacked bar, a gap or a zero may appear similar in a particular segment, so document missing data rather than letting a viewer assume it is zero.

Negative values require extra care. Excel can plot negative values, but negative segments extend on the opposite side of the zero line, making the visual structure less straightforward than a chart of positive contributions. If negative and positive amounts have different meanings, consider whether separate charts or a different chart type would communicate them more clearly.

Keep the chart current as data changes

If the source range will grow, format it as an Excel table before creating the chart. Select a cell in the data and choose Insert > Table, confirm that the table has headers, and then create the chart from the table. When you add rows or columns directly to the table, Excel can include the expanded table data in the chart automatically. Check the chart after structural changes, particularly if you add a new series or change a heading.

If the chart already exists, select it and use Chart Design > Select Data to inspect or revise the chart’s data range, series, and category labels. This is useful when Excel has omitted the first row, treated headings as values, or included an unwanted column. For a chart linked to a fixed range, adding data just below that range may not update the chart; adjust the range or convert the source into a table.

Common problems and practical fixes

  • The bars are grouped rather than stacked: the wrong chart type may have been selected. Use Chart Design > Change Chart Type and choose Stacked Bar.
  • The legend lists categories instead of series: select Chart Design > Switch Row/Column, then check that the category labels and legend entries are correct.
  • The chart includes an unwanted bar or segment: inspect the selected range for a totals row, totals column, notes, or an extra blank heading. Use Select Data to correct the range.
  • The 100% chart shows unexpected proportions: verify that the values in each row represent the components of one category and that the row totals are meaningful. A 100% chart normalizes each category separately.
  • Small segments or labels are unreadable: reduce the number of series, remove some data labels, or split the chart into focused views. Adding more colors or smaller text rarely solves the underlying density problem.

Also check that the chart’s number scale makes sense. A single unusually large value can compress the other bars, while inconsistent units can make comparisons misleading. Confirm the source values and their units before trying to fix a visual issue with formatting.

When another chart is a better choice

Use a clustered bar chart when comparing the individual values of each series is more important than seeing the combined total. In a clustered chart, series sit side by side, making comparisons easier for each category, though the overall total is less immediate. Use a line chart for trends over many time points when the emphasis is how values change over time, rather than how each period’s total is composed.

A stacked chart can become difficult to interpret when there are many series, many categories, or substantial negative values. A table with conditional formatting, a few small charts, or separate charts for related groups may communicate the information better. The best choice depends on the question: “How large is each total?” and “How does each total break down?” favor stacking; “Which series is larger?” often favors a clustered chart.

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. Each bar is scaled to 100%, so the segments compare proportions rather than actual totals.

How do I switch rows and columns in a stacked bar chart?
Select the chart and choose Chart Design > Switch Row/Column. This changes which data groups Excel treats as categories and which it treats as series; check the legend and category labels afterward.

Can I add totals above or at the end of stacked bars?
You can show segment labels through Chart Design > Add Chart Element > Data Labels, but this labels the component values, not necessarily the combined total. A common approach is to calculate totals in the worksheet and add them as labels using a supported chart-label workflow, or display the totals in a nearby table. Do not add the totals as another stacked series, because that counts the components twice visually.

Why are my bars not stacking?
The selected chart may be a clustered bar chart rather than a stacked bar chart. Select the chart, open Chart Design > Change Chart Type, and choose Stacked Bar. Also check that each intended component is a separate data series.

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 stack series to show each category’s total and component values; choose the orientation that makes your labels and comparisons easier to read.

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.