Clustered Stacked Chart

Hi,

I've been trying to create a Clustered Stacked Column chart but have been unable to achieve the desired result.

I've attached the data I'm working with. Basically, I want to show the cost of funds and overheads as one (stacked) column chart and right next to it the Interest & Fee Income - so I can compare revenue vs. expenses.
I'd also like to show the profit contribution with the Interest & Fee Income but I'm not sure that will look right.

I'd greatly appreciate any help someone could offer, as despite my efforts I'm unable to get it right.

Thanks,
Greg

Hello Greg,

follow Jon Peltier's tutorial here: http://peltiertech.com/clustered-stacked-column-bar-charts/


If you get stuck, post how far you got.

cheers, teylyn

I think because of the format of my data, which differs from the examples

From what I have been able to gather, data layout/format is key to getting a clustered and stacked column chart. If you are truly unable to rearrange the data or a copy of the data or use formulas to arrange the data in a suitable format for your desired clustered and stacked column chart, it may be very difficult to get what you want.

Can you clarify exactly what you want? It is not clear to me how you would like to cluster and stack (which series should be "clustered" side by side and which should be stacked) these data. If you could help us see exactly what you are trying to accomplish, we may be in a better position to suggest how to obtain it.

I think this is what you want but not sure how you intend dealing with the negative values

Further to above post I've removed the negatives and added month labels

I've done this before by creating another series putting into the primary axis (making it invisible) and making the present series secondary axis then linking the months to the new invisible series.

It's a pain to do and it will drive you crazy. I'll see if I can do it in the present format but I'll need to have a play around a bit first.

Here you go. I've left the background columns showing just so you can see what's going on. I had to make dummy data to set the background columns up to align the months. Just click on the grey columns and format to no fill to make them invisible