FG

Excel - stacked bar charts with two pairs of 'overlaps'

Fresh3 days ago
Mar 15, 202662851 views
Confidence Score0%
0%

Problem

I'm trying to do some 'stacked' bar charts in Excel 2010 - here's a close psuedo example. I want something like this: The buying and selling are side by side (left and right) grouped by team, and the target/results are overlayed (with whatever the smaller is in the foreground, or at least side by s…

Error Output

Team    Buying target   Buying result   Selling target  Selling result
Team A  80%     50%     70%     90%
Team B  50%     45%     95%     90%

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel - stacked bar charts with two pairs of 'overlaps'

Low Risk

Here is one way that might work for you. Set up the data like this: Make a column chart: Format the 'Actual' series, and put it on the secondary axis: Format the 'Target' series. give it no fill and a medium thickness border, and change the gap widt…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment