hi there,

sorry if this is in the wrong part of the forum, but i was wondering if someone could tell me how i would go about writing a macro to change the colour of one of 3 bars in a bar chart depending on the number the bar is drawn from?

basically i have a bar graph and if response rate comes at under 40% i want the bar to be red, and if it comes in at 40% and over i would like the bar to green.


any help is greatly appreciated.

Steve