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?

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

http://www.peltiertech.com/Excel/Cha...html#CondChart

stephanie wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html