Column Charts - Clustered and Stacked

[kws2710]

I am using Excel 2003 in Windows XP.

Is it possible to create a clustered, stacked column chart? I know how to create a cluster column chart and a stacked column chart, but i can not figure out how to combine the two.

Any ideas? Is it even possible?

 

[VoG]

Does this do what you want? click here

 

[teylyn]

Hi,

yep, it's possible. Jon Peltier offers great resources and tips.

Creating a Clustered-Stacked Column Chart.

Excel offers clustered column charts and stacked column charts among its standard options. How do you combine a stacked column chart with a clustered column chart?

Found in http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Enjoy

Teylyn

 

[kws2710]

This looks exactly like what I need. I'll give it a try.

Thanks!