Hi,

No need for code if you use some worksheet formula and multiple series.
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

ceemo wrote:
I have a bar graph and woulld like to have one of the bars change colour
depending on the value of a cell (1 - Green, 2 - Orange, 3 - Red). I
dont have a lot of experiance when it comes to coding graphs.

Please can you help,



--

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