change chart colors based on value?

[stevelucky]

I have a bar chart that I'd like to have change color based on the value. For example, the bar is gray until it reaches 30, and then it beomes green. any ideas?

 

[Benjamin1986]

The simplest way would be to write a macro that changed the color when it was above 30.

if thisworkbook.worksheets("data").cells(1,1) > 30 then
thisworkbook.worksheets("chartsheet").chartobjects("chartname").chart.seriescollection(1).forecolor.colorindex = 7
endif

Nice and easy to read.

Don't forget to include an "else" half of the statement that undoes the color change when it goes below 30.

 

[stevelucky]

so, which of those fields do i need to edit?

 

[Diffy]

I am almost ashamed to admit it, but sometimes I will copy a graph and paste it into Paintbrush. I can edit colors and ad text and lines in it, if you zoom in you cna make it look pretty good.

Just a thought.

 

[stevelucky]

well, that doesn't really help if it's a dynamic chart. if it were static and i didn't need it to be able to change that would be fine. and in that case, i could just change the chart color in excel. so, no, that doesn't quite help. thanks for trying though.