Stacked column, 2 values, percentage?
 

Greetings,

Using chart wizard, is there a way to do the following:

I would like to have a stacked column chart that shows a total amount
($170, in this case) in red, and a 'donated thus far' amount in green.
As donations come in, the green bar grows to - hopefully - eventually
cover the red bar...

Thus far I have only been able to come up with two columns side by
side.

Anton

Hi,

Here are some examples that should help.

http://j-walk.com/ss/excel/usertips/tip033.htm
http://www.andypope.info/charts/thermometer.htm

Cheers
Andy

wrote:
Greetings,

Using chart wizard, is there a way to do the following:

I would like to have a stacked column chart that shows a total amount
($170, in this case) in red, and a 'donated thus far' amount in green.
As donations come in, the green bar grows to - hopefully - eventually
cover the red bar...

Thus far I have only been able to come up with two columns side by
side.

Anton

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info