Both Stacked AND Clustered Charts

[Steveb1043]

Anyone who can help - -

Best as I can figure, it's impossible, but I want to make a bar chart
(columns) that is both clustered AND stacked.

I have 2 categories of data that both have 6 sets of 3 percentages. I
would like to display 6 clusters of 3 stacked columns (each column
being made up of my 2 categories).

If this is possible in excel 97, it has eluded me.

Please see attached picture as an example. ANY AND ALL help is greatly
appreciated.

 

[Debra Dalgleish]

If you stagger your data, you can create side-by-side stacked columns.
For example, with two departments over two years:

2001 2002

Exp1 DeptA 100 120
Exp1 DeptB 50 60

Exp2 DeptA 90 100
Exp2 DeptB 40 50

Bernard Liengme has an example and instructions on his site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

and 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

 

[Steveb1043]

Many thanks to you Debra Dalgleish for the reply!

It took some fiddling, but the chart looks great!

Thanks again