Changing bar graph colours in Excel

[peeryus]

Hi all,

I have a range of values between 0 and 100 that I need to represent on a bar graph. How can I, for eg. plot a green graph for values greater than 95, yellow graph for values between 80 and 95 and a red graph for values less than 80?

Thanks

 

[Refraction]

Home, Conditional Formatting, Color Scales

 

[peeryus]

Home, Conditional Formatting, Color Scales

Thanks for your reply. This only does it for the cells. Is there a way to transfer these rules to the graph?

 

[DrJohnZoidberg]

Thanks for your reply. This only does it for the cells. Is there a way to transfer these rules to the graph?

I only have the Mac version, and it doesn't look like it's possible. Might be different for Windows.

You could always do it manually.

 

[peeryus]

I only have the Mac version, and it doesn't look like it's possible. Might be different for Windows.

You could always do it manually.

Yeah was trying to avoid having to do that. Will check Google if its possible.