Excel Stacked Bar Chart With Negative Values

Charts & pivot tables · Updated November 19, 2026

Yes. Excel can display negative values in a stacked bar chart: positive series values stack to the right of zero, while negative values stack to the left. Select your category-and-series data, then choose Insert > Insert Column or Bar Chart > 2-D Stacked Bar; the key is to interpret the two sides as separate positive and negative totals, not as one net total.

How Excel stacks positive and negative values

A stacked bar chart places each category on its own horizontal bar and divides that bar into segments for the data series. With positive and negative numbers, Excel uses the zero line as the dividing point. Positive segments extend in one direction from zero, and negative segments extend in the opposite direction. Within each direction, the values are stacked in series order.

For example, a category with values 12, -5, and 8 will show a positive stack of 20 and a negative stack of -5. The chart does not show a single segment with a net value of 15. That distinction matters: the bar makes the positive and negative contributions visible, but readers must compare the two sides if they want to understand the net result.

The zero line is therefore more than a visual reference. It marks the point from which each sign is measured. If it is hard to see, or if the axis range clips part of a bar, the chart can give a misleading impression even though the underlying values are correct.

Arrange the worksheet data

Put categories in the first column and give each series its own column. Keep positive and negative values as real numbers, not text strings with a minus sign typed into them. A simple example is:

Region Gains Returns New sales
North 12 -5 8
South 7 -3 -4
West -2 6 9

Here, each row becomes a bar, and each of the three numeric columns becomes a colored series. North has positive contributions totaling 20 and a negative contribution of -5. South has a positive contribution of 7 and negative contributions totaling -7. Excel plots those groups on opposite sides of zero; it does not automatically combine them into a net figure.

  • Use clear, concise headings so the chart legend identifies each series.
  • Include units in the headings or chart title when values represent dollars, hours, percentages, or another measure.
  • Avoid blank rows or columns inside the selected data range, since they can cause Excel to detect the chart source incorrectly.
  • If categories and series appear swapped, use Chart Design > Switch Row/Column rather than rebuilding the chart.

Create a stacked bar chart in Excel

In Excel for Microsoft 365 on Windows, select the full data range, including its headings. On the ribbon, choose Insert > Insert Column or Bar Chart > 2-D Stacked Bar. Select the regular Stacked Bar option, not 100% Stacked Bar. Excel creates a horizontal chart with a separate bar for each category.

If you already have a chart, select it and choose Chart Design > Change Chart Type. In the chart-type window, choose Bar, then Stacked Bar, and confirm. This changes the display type without changing the worksheet values. If Excel has treated a row as a series when you intended it to be a category, try Chart Design > Switch Row/Column and check that the legend and category labels now match your data.

Excel for Mac has the same basic approach: select the range, use the Insert tab to choose a bar chart, and select Stacked Bar. Ribbon wording and layout can vary slightly by release. If you use Excel for the web, look for the bar-chart choices on the Insert tab; some advanced formatting controls may be more limited than in the desktop app.

Read the chart correctly

In a horizontal stacked bar chart, the category labels normally appear along the vertical axis, while the numeric scale runs horizontally. Positive values extend to the right of zero and negative values to the left under the usual axis orientation. The colors identify series, not whether a value is positive or negative, so a series may appear on both sides of zero across different categories.

Do not read the full length from the far-left end to the far-right end as a net total. In the North example, the distance from -5 to 20 spans both sides, but it is not a value of 25 or 15. If the business question is “What is the net result for each region?”, calculate or display that net separately. If the question is “Which sources add to or reduce the result?”, the stacked chart is a useful way to show contributions and direction.

Also distinguish a stacked bar from a clustered bar. A clustered bar places series side by side for each category, which makes direct comparison between series easier. A stacked bar emphasizes the composition of each category. When values include both signs, stacking helps show positive and negative contributions, but it can make comparisons between middle segments harder because those segments do not share a common starting point.

Format the zero line, scale, and labels

Make zero easy to locate. Select the horizontal value axis, right-click it, and choose Format Axis. In Axis Options, review the bounds and units. Automatic bounds often work, but you can set minimum and maximum values when you need consistent scales across several charts. Choose bounds that leave room for the largest negative and positive stacks; a bound that is too narrow can cut off bars or labels.

Use a visible zero line and light gridlines if they help readers estimate values. Avoid excessive gridlines or strong background fills, which compete with the data. If categories appear in an unexpected top-to-bottom order, select the category axis and inspect its options in Format Axis; the “Categories in reverse order” setting changes their display order.

Data labels can make the individual values explicit. Select the chart, use Chart Design > Add Chart Element > Data Labels, and choose a position that keeps labels readable. Depending on the chart and label position, a negative value may be crowded near zero or overlap another label. If that happens, try another label position, reduce the number of labels, or use a data table alongside the chart. Keep the minus sign visible, and format numbers consistently so readers do not mistake a negative value for a positive one.

Common problems and what to check

  • Negative numbers are missing or treated as text. Click a source cell and check that Excel recognizes its contents as a number. A leading apostrophe, imported text, or unusual dash character can prevent numeric plotting. Convert the values to numbers before charting.
  • The chart looks like a clustered chart. Check the selected chart type in Chart Design > Change Chart Type. Choose Stacked Bar, not Clustered Bar.
  • The legend or categories are wrong. Check the selected range and use Chart Design > Switch Row/Column if the data orientation is reversed.
  • A bar or label is cut off. Review the value-axis bounds and allow enough space on both sides of zero. Also check whether the chart area is too narrow for the labels.
  • The chart’s total seems wrong. Remember that the positive and negative stacks are separate. A regular stacked bar chart does not turn those segments into a single net-result display.

When another chart type is a better choice

Choose the chart based on the question, not just on the presence of negative values. A stacked bar is appropriate when the audience needs to see how multiple components contribute positively or negatively within each category. It is particularly helpful when there are only a few series and the category names are long enough to benefit from horizontal bars.

Use a clustered bar when comparing each series across categories is more important than showing a combined composition. Use a simple bar chart of calculated net values when the main question is which categories finish above or below zero. A waterfall chart can be a better fit when the aim is to explain how a sequence of increases and decreases leads from a starting amount to an ending amount. These charts answer different questions; they are not interchangeable ways to make the same data look different.

A 100% stacked bar is usually not the first choice for mixed positive and negative data. That chart type is intended to compare parts as proportions of a whole. With values on both sides of zero, the meaning of “100%” and the denominator needs careful explanation. Use it only when the proportion calculation is meaningful for your specific data and the chart’s behavior produces an interpretation your audience can verify.

Frequently Asked Questions

Can a stacked bar chart in Excel contain negative values?
Yes. Excel plots positive values on one side of zero and negative values on the other. Make sure the source values are numeric and choose Stacked Bar rather than Clustered Bar.

Why do my negative values appear on the left?
In the usual horizontal bar-chart orientation, negative values extend left from zero and positive values extend right. If the axis direction has been reversed or customized, inspect the value-axis options in Format Axis.

Does Excel subtract negative values from the positive stack?
No. Excel displays positive and negative values as separate stacks extending in opposite directions from zero. The chart does not show their net as one combined segment.

Can I show the net total on the same stacked bar?
A standard stacked bar is not designed to add a net marker or net segment automatically. Adding the net as another series would stack it and could misrepresent the data. Show the net in a nearby table or use a separate chart designed around net values.

Should I use a 100% stacked bar with negative numbers?
Usually not unless the percentages have a clearly defined, meaningful denominator for both positive and negative contributions. A regular stacked bar or a chart of net values is often easier to interpret.

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.