100% stacked column/clustered column

[Hans Knudsen]

Hello
I have a 100% stacked column chart (12 columns). The first two columns show data for:

EUN 2002
EUN 2003

The next two shows data for:
EUS 2002
EUS 2003

and so on.

I want to have EUN 2002 and EUN2003 placed without any space (as in a clustered column chart). Similarly for EUS 2002 and EUS 2003
and on.

Any help?

Hans Knudsen

 

[Jon Peltier]

Hi Hans -

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

These examples are given for simple stacks, but you can make 100%
stacked columns just as easily.

- Jon