I want to build bar charts (and possible other types) where the colors of the bars are a direct function of the value being charted. For example, I'd like to build an index chart where values above 100% result in a green bar, whereas values below 100% result in a red bar. I'm useless in VBA, so any assistance would be greatly appreciated.
Cheers,
Brian