Income vs Expenditure in Stacked graphs?

[Kate]

Hi
I'm sure this is simple but..!
I want a chart which shows one column with the income (say 500k) and
another (stacked) bar which shows how the income has been spent (eg:
food, wine, cinema etc).
The expenditure can be greater than the income: the income column is
really required for visual comparison!

Any suggestions, please? (i've got the stacked column: just can't get
the income column next to it!)

Cheers

 

[Debra Dalgleish]

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

Jan Feb

Food 200 180
Rent 400 400
Train 90 80

Income 3000 3000

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