CHART - can you combine a Clustered Collum & Stacked Col

djbe17

New Member
Joined
Jun 18, 2007
Messages
49
Office Version
  1. 365
Platform
  1. Windows
CHART - can you combine a Clustered Collum & Stacked Collum?

I have three sets of data, spend to date, manual Adjustment & Buget
it would like to be able to graphically shown this in a chart with the

Spend to date PLUS Manual Adjustement - STACKED to give a total, shown this agaist the budget sum .
So its kinda like a Stacked chart and clustered combined .

Hope this is clear, if not i'll have to go back to plan A - add the spend to date & Manual adjustment, and shown this as a clustered chart agaist the budget.

Thansks
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Yes this is possible - you just need to be careful how you set it up.

Set up data something like this -

Spend to Date, Col A
Manual Adjustment, Col B
Budget Sum, Col C

Then put all your values for Cols A and B on ODD numbered rows, and all your values for Col C on EVEN numbered rows, then create your stacked bar chart from this data.

Once you've got the basic chart set up, you'll understand how it works and can play around with it to make it look better.
 
Upvote 0
BINGO !
thanks for that, a simple solution that probably would have neaver, ever occured to me

Thanks.
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,913
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