Stacked Column Graphs

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.

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/...ips/Columns.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Robert wrote:

> 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.