Combine clustered column with stacked column?

Is it possible to combine a stacked and clustered column chart?

I have 12 series with 9 categories. For each of the 9 categories, I
want 4 clustered columns, each one of the four a stacked column of 3
of the series. I haven't figured out how to do this yet. Is this
possible and if so, how?

Thanks,
Eric

Eric -

You can make a clustered stacked column chart through clever arrangement
of your data in the worksheet. See the details at Stephen Bullen's site:
http://www.bmsltd.co.uk/Excel/SBXLPage.asp#Charting
and look at the description for FunChart4

or at Bernard Liengme's site:
http://www.stfx.ca/people/bliengme/E...ps/Columns.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Eric Stewart wrote:

Is it possible to combine a stacked and clustered column chart?

I have 12 series with 9 categories. For each of the 9 categories, I
want 4 clustered columns, each one of the four a stacked column of 3
of the series. I haven't figured out how to do this yet. Is this
possible and if so, how?

Thanks,
Eric