bar color "invert if negative" only white

[stephanie]

Hello,
I have a dynamic bar chart for which I want negative
values to be red and positive green. Because it's dynamic,
I can't simply take each bar and change it to red or
green - next time around the values are different.

I tried using the "invert if negative" feature (format
data series/patterns) but all I get is white as the
inverse color.
I also tried creating a pattern using both red and green
as colors but I always end up with ugly little dots of red
in my green bar or vice versa.

Any ideas?

 

[Debra Dalgleish]

Jon Peltier has instructions for conditional charts, which you could
adapt to your data:

http://www.peltiertech.com/Excel/Charts/format.html#CondChart