Overlay Bar Chart: Definition, Use Cases, and Examples

Overlay bar charts compare exactly two values per category by layering one bar in front of another, making gaps between actuals and targets instantly visible. This article explains the data requirements, walks through Excel's workaround for creating them, and shows practical examples from sales, inventory, and finance teams.

Key takeaways for overlay bar charts

An overlay bar chart places two bar series on the same axis, with one bar rendered in front of the other. The result? You instantly see the gap between two related values for each category.

Here's when this chart works and when it doesn't:

• Use this chart when: You have exactly two data series per category that share the same unit of measurement, and the insight you need is the gap between them.
• Avoid this chart when: You have three or more series, values are nearly identical, or the two series use different units.
• Primary decision supported: Quickly spot which categories are over or under a benchmark and by how much.
• Best alternative: Use a grouped bar chart (also called a clustered bar chart) when comparing more than two series, or a bullet chart when comparing a single metric against a target range.

Data requirements for overlay bar charts

Overlay bar charts look simple. The data has to behave, though, and that's where things get interesting.

Research in Harvard Business Review found "only 3 percent of companies' data meets basic quality standards." It's an important number because overlay bar charts pull from two series that often live in different systems. Mismatched data is where most of these charts go sideways.

Before you build anything, make sure these basics are true:

• Your category field matches across both series (same spelling, same IDs, same rollups).
• Your time grain matches (month vs month, week vs week). No mixing daily actuals with monthly targets unless you deliberately aggregate.
• Your metric definitions match everywhere the chart appears. "Revenue" is only helpful if it means the same thing in Sales, Finance, and the executive deck.

This is also why teams that care about governance (think IT and data leaders) push for a semantic layer and governed metrics. Poor data quality costs organizations $12.9 million per year on average. That's money lost to bad decisions, rework, and eroded trust in reporting.

What's an overlay bar chart?

The background bar represents one value, often a benchmark, target, or prior period. It's typically wider or lighter in color. The foreground bar represents the comparison value, like an actual, current, or measured metric. This bar is usually narrower or darker.

The difference between them is exactly what the chart reveals.

People use the terms overlapping bar chart and overlay bar chart interchangeably. You can orient the chart horizontally as a bar or vertically as a column. The logic stays the same either way.

When to use an overlay bar chart

Two related values per category. Same unit of measurement. And the insight you need is how one compares to the other (not their absolute magnitudes).

A few conditions must be true:

• Two series only: The chart breaks down visually with three or more series because bars stack and obscure each other.
• Shared unit of measurement: Comparing revenue in dollars to headcount in people on the same axis misleads viewers.
• Overlapping value ranges: If one series is consistently ten times larger than the other, the smaller bars become unreadable.
• Gap is the insight: If you need to show parts of a whole, use stacked bars instead.

This chart works well for actual vs budget by department, this quarter vs last quarter by product line, or current inventory vs reorder threshold by stock keeping unit (SKU).

Analysts and BI specialists like overlay bar charts for a simple reason: research published on the Social Science Research Network (SSRN) confirms "high-quality visualizations reduce cognitive load." Dual-metric visibility in one view means stakeholders don't have to toggle between charts or tabs to see variance. That matters more than most people realize when you're presenting to executives who have seven minutes and twelve opinions.

If you have more than two series, nearly identical values, or mismatched units, the overlay becomes hard to interpret. Use the limitations section below to choose a better chart for those cases.

How to make an overlay bar chart in Excel

Excel doesn't have a native overlay bar chart type. You create one by manipulating a clustered bar chart using the series overlap setting.

Prepare the data layout

Your data needs one column for category labels, one column for the background series (target, budget, or prior year), and one column for the foreground series (actual, current, or measured value).

If your two value columns use different units, stop here. Reconsider your chart choice.

If your target and actuals live in different tables (or different files), you also need a clean join key and matching time periods before Excel even gets a vote.

Insert a clustered bar chart

1. Select the entire data range including headers.
2. Go to Insert, click Chart, select Bar Chart, and choose Clustered Bar.

Excel renders two bars side by side for each category.

Adjust series overlap to create the overlay effect

1. Click on any bar in the chart to select the series.
2. Right-click and select Format Data Series.
3. In the Format Data Series pane, find Series Overlap and set it to 100 percent.
4. Adjust Gap Width to control spacing between categories. A value between 50 and 150 percent typically works.

One series should now appear in front of the other.

Change the plot order if the wrong series is in front

1. Right-click on the chart and choose Select Data.
2. In the Select Data Source dialog, use the up and down arrows to reorder the series.
3. Click OK and verify that the foreground series is now visible in front of the background series.

The series listed first plots in the background. The series listed second plots in front. If your actual values are larger than target values in some categories, those actual bars will cover the target bars entirely. This is expected behavior. The chart is showing that actual exceeded target. This is the part that trips people up most often. They assume the chart is broken when it's working exactly as designed.

Format for clarity

1. Select the background series and apply a lighter or muted fill color.
2. Select the foreground series and apply a darker or more saturated fill color.
3. Add data labels if precise values matter, positioning them outside the bars.
4. Remove or simplify the legend if the two series are obvious from context.

Look at each category. Can you see both bars?

Limitations of building overlay bar charts in Excel

You can't independently control bar widths for each series without using a secondary axis workaround. This introduces axis sync problems.

If your data updates frequently, you must manually adjust formatting each time. Conditional formatting (like coloring bars red when actual falls below target) requires helper columns.

If you're blending multiple sources, say, a quota table from a customer relationship management (CRM) system and actuals from an enterprise resource planning (ERP) system, the hardest part is usually upstream. Data engineers often have to align schemas, match time grains, and keep refresh schedules in sync so the chart doesn't quietly drift out of date.

For dashboards that refresh automatically, a BI platform like Domo handles overlay bar charts natively with built-in formatting rules. In Domo BI, teams can also standardize the definitions feeding the chart through a semantic layer and reusable metrics, so the "actual vs target" math stays consistent wherever it appears.

Overlay bar chart examples

Sales performance vs quota by region: Sales leaders monitor which regions hit quota and which fell short. The gap between the actual bar and the quota bar shows shortfall or surplus at a glance. Regions where actual exceeds quota have the foreground bar extending past the background bar. A stacked bar would show totals but not the gap. A grouped bar would require mentally calculating the difference.

This is also a classic sales operations dashboard pattern. People want forecast vs actual revenue by region in one chart so they can spot underperforming territories without extra slides.

Current inventory vs reorder threshold by SKU: An operations team monitors stock levels against minimum thresholds. SKUs where the current bar is shorter than the threshold bar need immediate attention. A line chart would show trends over time but not the threshold comparison. A table would require scanning numbers rather than seeing the gap visually.

In practice, teams often want this view on mobile during standups or floor walks. That's when an interactive, mobile-ready overlay bar chart beats a static screenshot.

This year vs last year revenue by product line: A finance team reviews year-over-year performance. Products where this year's bar is shorter than last year's bar are declining.

Limitations of overlay bar charts and when to use alternatives

Overlay bar charts work for exactly one type of comparison. The gap between two values per category. That's it. Outside that narrow use case, they mislead or clutter.

Three or more series? Bars stack and occlude each other. The viewer can't distinguish which bar belongs to which series. Use a grouped bar chart instead.

When values are too similar, the foreground bar hides the background bar. The viewer sees only one bar and assumes no gap exists. Use a grouped bar chart or add data labels showing the difference.

Placing revenue in dollars and units sold as a count on the same axis creates false equivalence. Use a dual-axis chart with extreme caution, or separate the metrics into two charts.

If the question is what share of the total each segment represents, use a stacked bar chart. If the question is which category is largest, use a simple bar chart sorted by value.

And if the problem is that two departments can build two different "budget" definitions? You don't need a different chart type. You need governed metric definitions (the kind that stop the boardroom debate over whose numbers are right). This exact argument derails quarterly reviews more often than it should.

Build overlay bar charts faster in Domo

If you build overlay bar charts repeatedly, Excel's manual formatting becomes a time sink. Updating them with new data or sharing them across teams requires constant manual intervention.

Domo BI handles overlay bar charts natively with no secondary axis workarounds. You get automatic data refresh from connected sources. You can apply conditional formatting rules without helper columns. Role-based access ensures the right people see the right data without emailing spreadsheets.

A few Domo pieces tend to matter as teams scale this chart across dashboards:

• Governed consistency: A semantic layer and reusable metrics help analysts avoid rebuilding calculated fields and arguing about definitions across reports.
• Clean, joined data: Magic Transform (including Magic ETL) helps people blend, join, and align targets and actuals into a single dataset so the overlay is comparing apples to apples.
• Drill-down and follow-ups:Interactive dashboards let executives click into a bar to explore details, and AI chat and natural language query can help managers ask quick questions without leaving the chart.

If you want these overlay bar charts to show up outside your BI workspace, Domo Embed lets you place interactive dashboards (including overlay bar charts) directly in a customer portal or website with permissions that control what each person can see.

And if you're tired of chasing people for status updates, Domo Apps can schedule report delivery and trigger alerts when the gap between the two overlaid metrics crosses a threshold.

Low-code App Studio also gives teams a way to put overlay bar charts inside custom, data-driven apps without writing code. Handy when you want the chart to live where work actually happens.

If you're ready to ditch the Excel series-overlap gymnastics and build always-up-to-date actual-vs-target overlays with governed metrics and automated alerts, Try free and see how fast your variance stories snap into focus.