Multiple Series of Series in Stacked Column chart?

[Guest]

I'm using Excel 2000, and I'd like to see if there is a way to create a
chart using multiple series of series in a stacked column chart (2D).

Specifically, I have several series defined by a VBA program, and they
are graphed along six categories. I want to group those categories
together and then group again by month. It should look like a common
Clustered Column graph, but instead of normal columns, each one would be
a stacked column. In the end, there will be three months shown along the
x axis, each month showing six categories with six stacked columns. The
colors in the stacked column will be each of my series.

Alternatively, is there a way to create a 3D stacked column graph? I
don't think 3D will represent the data as well, but it would work as an
alternative.

Nathan

 

[Jon Peltier]

Nathan -

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.ie/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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Jon Peltier]

Nathan -

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.ie/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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______