stevelucky
Board Regular
- Joined
- Oct 6, 2006
- Messages
- 126
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?
if thisworkbook.worksheets("data").cells(1,1) > 30 then
thisworkbook.worksheets("chartsheet").chartobjects("chartname").chart.seriescollection(1).forecolor.colorindex = 7
endif