Column overlaying in column charts

JulesnPat

New Member
Joined
Nov 8, 2005
Messages
2
I am trying to produce a column chart (or preferably a floating bar chart) that shows performance against target, where the target number is the full column and the actual performance is represented as part of that column. I think I need to somehow overlay the actual value column over the target one but I don't know how. I've had a look at previous questions but nothing quite matches what I need - can anyone help please?
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
I think that my following example may be what you are looking for.

In A1:A3, I entered the performance values 10, 110, 80.
In C1:C3, I entered the target values 60, 160, 100
In B1, I entered =C1-A1, and copied down.

I highlighted the range A1:B3, clicked on the Chart Wizard, chose Column for the Chart type:, then chose the second figure on the first line, under Chart sub-type, then Finish.

My chart now shows columns of the height equal to the target value, each column with two parts, the bottom one is the "Performance" value you want, and the top part is the amount needed to reach the performance desired.

Let us know if this solves your problem.
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,908
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top