Adding additional stacked column in excel chart

[hschwarz]

Hi,

Is there a way to add an additional stacked column from a different set of data in an excel graph?

See file attached, I basically just want another stacked column showing the mix of current resource availability for 'Ops' & 'Planning'.

I hope it makes sense.

Regards,

[MrShorty]

I am having trouble understanding what you want to do.

As a guess, are you looking for a "clustered and stacked" column chart? https://peltiertech.com/clustered-st...mn-bar-charts/

[hschwarz]

Hi,

Thanks for quick reply. And yes, that's what I meant.
Is there a better way of doing that in excel or is that the only way?

Regards,

[MrShorty]

Perhaps I am a bit too enamored of Peltier's work, but, if there were a better of doing a clustered and stacked column chart, I think Jon Peltier would be the one to know and write about it. Because Jon has not mentioned a different way of doing it, I expect this is the best way to do it.