Stacked Bar Chart

[Mike Steklac]

I would like to create a stacked bar with categories of expenditures
(personnel, capital outlay, operating expenses, etc.) with a stacked
bar for each department in the budget AND I would like several stacked
bars for each department with each bar representing a fiscal year.
The x-axis would be departments. Does anyone know how to do this in
Excel?

 

[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