custom charting

[mel]

I would like to make a stacking chart with one customized
feature: We have three categories and would like to have
category 1 have its own bar and have categories 2 and 3
stacked on each other, next to category 1.

There are seven values (2004-2010) for each category, if
that makes a difference.

Thanks for any help!!!!!

mel

 

[Debra Dalgleish]

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

2004 2005

CatA 100 120
CatB 50 60

CatC 90 100

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