Stacked Bar Chart Not Working in Excel? Fix It

Charts & pivot tables · Updated November 20, 2026

If a stacked bar chart in Excel is blank, has the wrong segments, or looks nothing like the source data, check the data layout and chart type first. Put categories in the first column, each stack component in its own column, select the full range including headers, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar.

Start with the quickest checks

Many chart problems come from Excel interpreting the selected cells differently than intended. Before rebuilding the chart, click it and compare its displayed categories and series with the worksheet. If the chart is empty or incomplete, check that the source range includes the actual numbers, not just labels, and that the values are numeric rather than text.

  • Wrong chart shape: Choose a stacked bar chart, not a clustered bar chart or a stacked column chart. A bar chart uses horizontal bars; a column chart uses vertical ones.
  • Wrong data orientation: On the Chart Design tab, select Switch Row/Column and see whether the categories and series fall into place.
  • Missing series: Use Chart Design > Select Data to inspect the chart’s source range and listed series.
  • Unexpected scale: Right-click the value axis, choose Format Axis, and check its minimum, maximum, and number format.
  • Hidden or filtered data: In the Select Data Source dialog, choose Hidden and Empty Cells and review whether data in hidden rows and columns is included.

These checks are usually faster than deleting the chart. If you do need to recreate it, first confirm the table is organized as described below.

How stacked bar charts use your data

A stacked bar chart displays one horizontal bar for each category, divided into segments for the different data series. For example, a table of quarterly product sales can have quarters down the first column and separate columns for Product A, Product B, and Product C. Each quarter becomes one bar, and each product’s sales become a segment in that bar.

A simple layout looks like this:

  • Column A: category names, such as Q1, Q2, and Q3.
  • Row 1: series names, such as Product A, Product B, and Product C.
  • The cells inside the table: numeric values for each category and series.

Include the header row and category labels when selecting the range. Excel uses those labels to name the legend entries and category axis. If the first row or column is missing from the selection, Excel may assign generic names such as Series 1, or treat a label as a value. Avoid blank rows or columns inside the table; they can break up the selected range or make Excel infer the data boundaries incorrectly.

For instance, if rows represent months and columns represent departments, each month can be a bar and department values can form its segments. If you instead want one bar per department, with months as the segments, switching rows and columns changes that interpretation. Neither orientation is inherently wrong: choose the one that answers the question your chart is meant to show.

Confirm that the chart type is actually stacked

Excel offers several similar-looking choices. A clustered bar chart places series side by side for each category. A stacked bar chart places series end to end in one bar. A 100% stacked bar chart scales each category to the same total length, showing proportions rather than the original totals. Choosing the wrong one is a common reason a chart appears not to work.

To change an existing chart in Excel for Microsoft 365 on Windows, select the chart, open Chart Design > Change Chart Type, choose Bar, and select Stacked Bar or 100% Stacked Bar. The standard Stacked Bar option preserves the values’ totals; 100% Stacked Bar expresses each segment as a share of its category’s total. If all your categories have the same full-length bars, you may have chosen the 100% version.

On Mac, select the chart and use the Chart Design tab’s Change Chart Type command; the dialog labels may be arranged differently, but the chart families and stacked options are similar. In Excel for the web, chart editing options can be more limited or arranged differently from the desktop ribbon. If a setting is unavailable, open the workbook in the desktop app.

Repair missing, mislabeled, or reversed series

Select the chart and choose Chart Design > Select Data. The Select Data Source dialog shows the chart data range and the series included in the chart. If a series is absent, extend the chart data range to include its column or use Add to define the series. A series needs a name cell and a range of numeric values; its values should correspond to the category labels on the horizontal category axis.

If the legend shows category names where series names should be, or the bars represent the wrong grouping, try Switch Row/Column in the same dialog or on Chart Design. This tells Excel to treat rows as series instead of columns, or vice versa. Check the resulting legend and category labels rather than relying on the preview alone.

Pay attention to whether the data range includes a total column or total row. Adding totals as another series stacks the total on top of its components, overstating the bar. For example, if a row contains sales for three departments and a separate grand total, charting all four numbers makes the bar show the departments plus the total again. Exclude totals from the source range unless they are intentionally a separate component.

Check values, blanks, and cell formatting

A cell can look numeric but still be stored as text. This can happen when values have been imported, contain leading apostrophes, or include extra characters. Excel may omit text values from a numeric chart or treat them as zero. Click a suspicious source cell and inspect the formula bar and number format; test a small sample by retyping the value or converting the imported column to numbers. Do not remove symbols or change data until you know whether they are part of the intended value.

Blanks, zeros, and errors have different meanings. A zero is a real value and normally contributes no visible segment. A blank may create a gap or be handled according to the chart’s empty-cell setting. An error such as #N/A can prevent a value from plotting as expected. Resolve errors in the source data if they are unintended, and use Chart Design > Select Data > Hidden and Empty Cells to review how empty cells are displayed. Excel does not treat every missing value as a zero automatically.

Also check whether numbers are negative. Stacked charts can plot positive and negative values on opposite sides of the zero baseline, so the visual may appear split or have segments extending in different directions. That is not necessarily a rendering fault; it may accurately reflect the data. If negative entries are unexpected, verify the source values and signs.

Fix axis and label problems

In a bar chart, the category axis runs vertically and the value axis runs horizontally. This can be confusing because Excel’s axis formatting options may refer to the value axis even though it is drawn across the chart. If bars seem compressed, select the horizontal value axis, right-click, and choose Format Axis. A manually fixed minimum or maximum can clip bars or leave them very short; set the bounds back to automatic when you want Excel to fit the data.

If the category order looks backwards, select the vertical category axis and open Format Axis. The Categories in reverse order option changes the display order. Reversing categories may also move the value axis to the opposite side, so check the axis crossing setting if the result is awkward. These settings affect presentation, not the values in the worksheet.

Data labels can also make a correct chart look broken. Segment labels may overlap when there are many categories, small values, or long series names. Select a label and use the formatting options to choose a suitable label position, or remove labels and rely on the legend. For a crowded chart, widening the chart, reducing the number of categories, or labeling only selected values can improve readability more than shrinking the font.

When the chart is blank or will not update

If the chart is blank, confirm that its source range actually contains numeric data and that the chart has not been filtered to show no categories or series. Select the chart, open Chart Design > Select Data, and inspect the range. A range that points to empty cells, the wrong worksheet, or only headers will not produce the intended bars. If the source is an Excel table, adding rows directly beneath it usually expands the table, but check that the chart’s source range includes the new rows.

For a chart that does not reflect edits, make sure calculation and workbook links are not the underlying issue. Check that you changed a cell inside the chart’s source range, and look for filters on the chart or its source table. If the chart is based on a PivotTable, refresh the PivotTable using PivotTable Analyze > Refresh. A PivotChart follows its associated PivotTable, so changing cells outside that pivot summary will not necessarily change the chart.

If a chart seems frozen after copying or moving data, inspect its source reference rather than assuming the chart needs repair. In Select Data, confirm the worksheet and cell addresses. When a workbook is opened in a different app or an older Excel version, some formatting or interactive behavior can differ; open it in Excel for Microsoft 365 and save it there if you need the current desktop chart controls.

Choose the right stacked chart for the question

Use a standard stacked bar when both the category total and the contributions to that total matter. It makes the overall length of each bar easy to compare, but only the first series shares a common starting point, so comparing interior segments across categories can be difficult. Keep the order of series consistent and put the most important or easiest-to-compare series first.

Use a 100% stacked bar when the question is about composition—for example, what percentage of each department’s budget went to different expense types. It is useful for comparing proportions, but it hides differences in total size: two categories with very different totals both fill the same bar length. If totals matter as well, show them in a separate column or chart, or use a standard stacked bar.

If you need to compare individual components precisely across many categories, a clustered bar chart may be clearer because each series has its own baseline. A stacked bar is not automatically the best choice just because the data has several series. The chart should match the comparison you want readers to make.

Frequently Asked Questions

Why is my stacked bar chart showing only one color?
If the chart has one series, it has only one segment color per category. Check the table layout and Select Data to confirm that each component has its own column or row and is included as a separate series. If several series are present but look like one color, check formatting and whether some values are zero.

Why are my bars not stacking in Excel?
The chart may be set to Clustered Bar instead of Stacked Bar. Select it and go to Chart Design > Change Chart Type > Bar > Stacked Bar. Also confirm that the values you want stacked are separate series, not separate categories.

Why does my 100% stacked bar chart show equal-length bars?
Equal full lengths are the purpose of a 100% stacked chart: it compares each series’ share of its category total. Choose the standard Stacked Bar type if you need bar length to reflect the actual total.

How do I add another category to a stacked bar chart?
Add the category and its values next to the existing source data, then check Chart Design > Select Data to make sure the chart range includes the new row or column. If your source is an Excel table, adding the data to the table may expand the range automatically.

Can a stacked bar chart show negative numbers?
Yes. Negative values can extend in the opposite direction from positive values around the zero baseline. Confirm the signs in the worksheet and adjust the value-axis bounds if necessary; do not change negative values simply to make the bars look uniform.

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.