Combine clustered column with stacked column?

[Eric Stewart]

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

 

[Jon Peltier]

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/ExcelTips/Columns.htm

- Jon