Chart Colour

[ceemo]

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,

[Anton]

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

[Anton]

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