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,


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=551156

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

make a so-called conditional chart. This can be automated by making columns
of yr data for each colour you want (in yr example 3 columns), and putting an
if-statement that writes the value if the condition is right for the colour
or #NA() if the value falls outside the conditions. Make sure that the value
always is displayed in one of the three columns. Plot the cells with the
IF-statements as three different series.
HTH,
Henk

"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,


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=551156

wow the link (above) is really handy but i cant work out where the
colours have been linkes to the criteria ?


Anyone know?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=551156

If I understand your question the actual colour of each bar series would
have to be set manually.

ceemo wrote:
wow the link (above) is really handy but i cant work out where the
colours have been linkes to the criteria ?


Anyone know?



--

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

hmm but when i change the value of the random values the cell colour
automatically changes? How is this possible if the colours havent been
predifined for each criteria range?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=551156

the cell colours change?? Are you talking about conditional formatting
of cells now rather than the chart columns?

ceemo wrote:
hmm but when i change the value of the random values the cell colour
automatically changes? How is this possible if the colours havent been
predifined for each criteria range?



--

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