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=551071

is this on a powerpont or word?

"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=551071

sry didnt read the header, duh, Excel. In order ot do this you will have to
create a macro. Tommorrow I will help you more out with this.

"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=551071