Stacked column within a column chart

[Dave]

I have created a column chart that has 10 X-axis
categories. Each category has 4 data values (columns). I
need to add a 5th data value by making the 4th column a
stacked column with the 5th data values. Therefore each
of the categories will have 3 normal columns and the 4th
will be a stacked column. Is this possible? If so, how
do I do this? Thank you for your help!

 

[Jon Peltier]

Dave -

Through careful arrangement of the data in your worksheet, you can make
a stacked column chart that looks like a clustered-stacked column chart.

There is a tutorial showing this technique on Bernard Liengme's site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

which is based on the example on Stephen Bullen's web site:
http://www.bmsltd.co.uk/Excel/Default.htm
Go to Charting Examples, and download FunChart4.xls

The following MSKB article has an example:
XL2000: Creating Charts with Multiple Groups of Stacked Bars
http://support.microsoft.com/default.aspx?scid=kb;en-ca;214119

- Jon