Clustered-Stack Charts In Excel 2007??

[danielhitch]

Is there a way I can produce a clustered-stack chart in Excel 2007 without using PTS Clustered Stack Chart Utility?

Thanks in advance!!

 

[xld]

Yes, but you need to reformat your data, and then do a bit of magic on that data.

In essence, create the data in a format where the clusters occupy separate columns alongside each other, the stacking goiung down. I did an example on VBAEXpress yesterday, you can see it at http://www.vbaexpress.com/forum/showthread.php?t=25473, the best example is in post #11