format colors on bar charts by value
 

I'm working on a Bar chart with 5 bars. What I would like to do is change
the color of each bar depending on the number it is graphing. My table is
very simple, column A is the data names, column B are the values from 0 to 3.
If the value is 1 I would like it to change the color of the bar to red, if
it is 2 I'd like it to change to yellow, if it is 3 I'd like it to change to
green.

Can this be done?

Thanks
Bill

format colors on bar charts by value
 

See http://peltiertech.com/Excel/Charts/...nalChart1.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"BillC" wrote in message
...
I'm working on a Bar chart with 5 bars. What I would like to do is change
the color of each bar depending on the number it is graphing. My table is
very simple, column A is the data names, column B are the values from 0 to
3.
If the value is 1 I would like it to change the color of the bar to red,
if
it is 2 I'd like it to change to yellow, if it is 3 I'd like it to change
to
green.

Can this be done?

Thanks
Bill