Overlapping Stacked Bar Chart in Excel: How to Make One

Charts & pivot tables · Updated November 20, 2026

Yes—but Excel does not have a dedicated chart type called an overlapping stacked bar chart. In Microsoft Excel for Microsoft 365 on Windows, a practical way to make one is to build two 2-D stacked bar charts, make the upper chart transparent, and align it over the lower chart.

What an overlapping stacked bar chart shows

A stacked bar chart divides each horizontal bar into segments. Each segment represents a component of a total, such as labor, materials, and travel costs. An overlapping version places a second stacked bar for the same categories on top of the first, usually to compare two periods, plans, or groups.

For example, imagine comparing a planned budget with actual spending for January, February, and March. Each month has three components. The lower chart could show the planned breakdown, while the overlaid chart shows actuals. A reader can compare both the overall lengths and the component segments.

That comparison comes with a trade-off: the front bar can hide the bar behind it. Transparency, contrasting colors, or slightly offset bars can help, but the chart may still be harder to read than two charts side by side. The method is most useful when the categories and component definitions match between the two data sets.

What Excel’s chart options do—and do not—do

Excel provides a 2-D Stacked Bar chart type, which stacks the series within each category. It also provides a Series Overlap setting for certain bar and column charts. That setting controls how series in a chart relate to one another; it does not create two independent stacked totals that can each be positioned as a separate layer.

So, changing Series Overlap is not a reliable substitute for layering two complete stacked charts. Excel’s standard chart tools do not provide a single, dedicated command for that particular design. Building two chart objects gives you separate control over each stack, at the cost of extra setup and maintenance.

Before choosing this approach, decide what the visual comparison needs to emphasize. If exact values matter, data labels or a table may be more useful than overlapping colored segments. If the audience needs to compare totals quickly, a clustered chart or a pair of side-by-side stacked charts is often clearer.

Prepare matching data for both charts

Start with two clean tables that use the same category order and the same component columns. For example, one table might contain the planned values and another the actual values, with months as rows and Labor, Materials, and Travel as columns. Use identical units in both tables.

  • Keep the category names consistent. “January” in one chart should not appear as “Jan” in the other.
  • Use the same component order in both tables so the colors correspond.
  • Check that blanks and zeros mean what you intend. A blank can be treated differently from an explicit zero in some chart contexts.
  • Decide whether negative values are meaningful. They can make a stacked comparison harder to interpret and may require a different chart design.
  • Include totals in the source data only if you intend them to be a plotted series. Usually, a total column should be excluded from the stacked chart because it would add another segment rather than label the bar.

For a fair visual comparison, both charts need the same category order and value scale. If one chart’s horizontal axis reaches 100 and the other reaches 150, equal-looking bar lengths no longer represent equal values.

Create the two stacked bar charts

In Excel for Microsoft 365 on Windows, select the category labels and component values for the first data set. Choose Insert > Insert Bar or Column Chart > 2-D Stacked Bar. Repeat for the second data set. Use the standard stacked option, not 100% Stacked Bar, unless you specifically want to compare proportions rather than totals.

Check each chart before combining them. If Excel has treated the component names as categories, or the months as series, select the chart and use Chart Design > Switch Row/Column. The correct orientation should show one bar per month, with the components forming segments within each bar.

Give the charts useful titles while you work, such as Planned and Actual. You can also set the same colors for matching components in both charts. For instance, use blue for Labor in each chart, green for Materials, and orange for Travel. Matching colors are essential: using unrelated colors makes it difficult to identify corresponding segments.

Layer and align the charts

  1. Place both charts on the same worksheet, and resize them to the same overall width and height.
  2. Set each chart’s horizontal value axis to the same minimum and maximum. Right-click an axis, choose Format Axis, and enter matching values under Axis Options > Bounds. If you leave the bounds on Auto, Excel may choose different scales.
  3. Move one chart over the other. Drag its outer border so the plot areas—the regions containing the bars—line up as closely as possible.
  4. Select the upper chart. On the chart formatting controls, set the Chart Area fill to No Fill and its outline to No Line. Set the Plot Area fill to No Fill as well, so the lower chart can show through.
  5. Remove duplicate visual elements from the upper chart if needed. For example, hide its value axis, category axis, title, and legend when those elements would cover or duplicate the lower chart.
  6. Inspect the plot areas, not just the outer chart edges. Titles, legends, and axis labels affect the available plotting space, so two equal-sized chart objects do not always have plot areas of equal size.

For a more controlled alignment, adjust the chart sizes and positions gradually and compare the bar centers and axis endpoints. Excel may allow object alignment commands when multiple chart objects are selected, but matching the plot areas can still require manual adjustment. On Mac, the chart-creation choices are similar, but ribbon labels and formatting controls can differ slightly by Excel version. In Excel for the web, chart editing capabilities may be more limited; use desktop Excel if you cannot access the necessary formatting controls.

Make the overlap readable

Once the charts are aligned, the main challenge is preventing one layer from obscuring the other. A fully opaque upper chart hides the bars beneath it, even if the chart background itself is transparent. The upper chart’s data series need to be visually distinct and, where appropriate, partly transparent.

Select a segment in the upper chart, open Format Data Series, and use Fill & Line options to choose a fill color and adjust its transparency. Apply consistent formatting to the other upper-chart series. A moderate transparency can reveal the lower chart, but too much can make the colors blend into an unclear third color. Test the result at the size readers will actually see, especially if the chart will be printed.

Other options include using a lighter tint for the back chart, adding a clear legend that identifies each layer, or shifting one chart slightly so both outlines remain visible. A shift can make the comparison easier to see, but it also means the bars are no longer precisely aligned; label the design clearly so readers do not mistake the offset for a different category position.

Interpret totals and segments carefully

In a stacked bar, the total is the full bar length, while each component’s position depends on the values of the segments before it. This makes the first segment especially easy to compare because it starts at the axis. Later segments begin where earlier segments end, so their starting positions vary. Overlapping two stacks adds another layer of visual complexity.

For example, if Labor is the first segment in both charts, its lengths can be compared from the same zero point. Materials may be more difficult to compare directly if Labor differs between the two periods, because the Materials segments start at different positions. Consider adding data labels, a separate table of values, or a second chart focused on individual components when precise segment-by-segment comparison is important.

Also distinguish totals from percentages. A standard stacked bar compares amounts and total lengths. A 100% Stacked Bar normalizes each category to 100%, making it useful for comparing composition but hiding differences in overall size. It is not a way to make two complete stacks overlap; it answers a different question.

Common problems and fixes

  • The background chart disappears. Make both the upper Chart Area and Plot Area transparent, and check whether the upper data series themselves are opaque.
  • The bars do not line up. Match chart dimensions, axis bounds, category order, and plot-area size. Removing a title or legend from only one chart can change the plot-area layout.
  • The bars use different scales. Set the same horizontal-axis minimum and maximum for both charts rather than relying on Auto bounds.
  • The categories appear in reverse order. Check the category axis settings in Format Axis. Excel may display the first category at the bottom or top depending on the axis options.
  • The colors do not correspond. Format matching component series to use the same colors in both charts, and make the legend explain which chart represents which data set.
  • The chart becomes difficult to edit. Two overlaid charts can be awkward to select. Click the chart border, or use the Selection Pane if available, to choose the intended object. Keep a separate copy of the data and avoid placing other chart objects directly beneath the overlap.

When a different chart is better

Use side-by-side stacked bars when readers need to compare the full component breakdown for two periods without one stack hiding another. Use a clustered bar chart when the main task is comparing individual values across groups and stacking is not essential. Use a 100% Stacked Bar when the key question is how each category’s composition changes, not how its total changes.

A line chart can work better for monthly trends, particularly when the values represent a continuous time series. A table with conditional formatting may be clearer when readers need exact values. If you want to compare both totals and component changes, consider a small set of simple charts rather than forcing every comparison into one layered graphic.

To keep the overlaid version useful, include a title that names both data sets, a legend that identifies the layers, and a note about whether the bars show amounts or percentages. If the visual is shared as a printed report or static image, make sure transparency and contrast remain clear outside Excel.

Frequently Asked Questions

Can Excel make an overlapping stacked bar chart with one chart?
Excel has no dedicated one-click chart type for two independent stacked bars layered over one another. The straightforward approach is to create two stacked bar chart objects, make the upper one transparent, and align them.

Does Series Overlap create overlapping stacked bars?
No. Series Overlap controls how series are positioned in supported bar or column charts. It does not independently stack two data sets and layer one complete stack over another.

Should I choose Stacked Bar or 100% Stacked Bar?
Choose Stacked Bar to compare amounts and totals. Choose 100% Stacked Bar to compare each category’s percentage composition; it makes every bar the same overall length.

Why can’t I see the lower chart?
The upper chart may have an opaque Chart Area, Plot Area, or data-series fill. Make the chart and plot backgrounds No Fill, then adjust the upper series fills or transparency.

Is an overlaid chart always better than two charts?
No. It saves space, but overlapping segments can obscure values and complicate comparisons. Side-by-side stacked bars, clustered bars, or a table are often easier to understand.

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.