Multiple Columns in a stacked column chart

[Justin]

Is it possible to create multiple columns of stacked data
sets? For example: can I plot monthly data in which each
month is the sum of 3 categories, but plot these stacked
columns for 2 years (side by side per month)? This
enables me to compare last years monthly totals versus
this years monthly totals on a per month basis?

 

[Jon Peltier]

Justin -

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

 

[Leslie]

With much trepidation, I am thinking of trying to do what you want to do.

I found that Stephen Bullen's website, referred to by Jon Peltier, was under
reconstruction, so couldn't download from it.

One other source of information I found on the topic was at
www.excelforum.com, under the heading "Combined columnar chart (3-5 columns)
and stacked column (1 column, 2 series) as one chart".

 

[Debra Dalgleish]

Jon included an old link -- here's the updated one:

http://www.bmsltd.ie/Excel/Default.htm
Go to Charting Examples, and download FunChart4.xls