Excel graphs

[Richard]

Hi all

Is it possible to have a clustered stacked bar chart. In
other words to have one stacked column for Jan 2003, and
next to it a stacked column for 2004, then the same for
February etc.

I'm using XP.

Many thanks

 

[Don Guillett]

If I understand properly and your layout is
jan feb
1 10
2 12
3 14

Then just higlight>select your chart icon>stacked bar>rows

 

[Andy Pope]

Cribbed from Debra Dalgleish's answer to a previous post.

If you stagger your data, you can create side-by-side stacked columns.

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?id=214119

Cheers
Andy