Stacked Column Graphs

[Robert]

What I would like to do is something I thought was very
simple, create a chart that compares total costs vs total
funds over a period of years.

I have a total of five columns of data. I want to select
three columns to be in a stacked column graph (showing
total Funds). I then want to create a second stacked
column graph to sit beside the first one made from the
remaining two columns of data (showing total Costs) for
the same time period. The years will go along the X axis
and the total dollars along the Y axis.

I can do this so easily on graph paper, but for the life
of me I cannot figure out how to get Excel to do the same
thing.

Any suggestions?

Thanks in advance for your assistance.

 

[Jon Peltier]

You can make a clustered stacked column chart through clever arrangement
of your data in the worksheet. See the details at Stephen Bullen's site:
http://www.bmsltd.co.uk/Excel/SBXLPage.asp#Charting
and look at the description for FunChart4

or at Bernard Liengme's site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

- Jon