Changing color of negative bar when using Invert if negative

  • Thread starter Thread starter Breck
  • Start date Start date
B

Breck

I have multiple bar charts in Excel 2007 that I am using the Invert if
negative option. After right clicking on the bar of each chart and
choosing "format data series" then "Fill" then "Invert if negative"
all of the bars that are negative are changed to the color white or
possible transparent. I can change the color of the positive bars but
I can't find where to change the color of the negative bars from
white. Anyone know how to change the color or the negative bar? Any
help would be appreciated.
 
That doesn't work in Excel 2007 the instructions are for Excel 2003. I
already tried it before posting this.
 
That doesn't work in Excel 2007 the instructions are for Excel 2003. I
already tried it before posting this.
 
Sorry, I don't seem to see that option in Excel 2007.

You could try creating two series - one for positive numbers and the other
for negatives. You could then format each series to the color that you want.
 
I tried a handful of tricks which make this work in 2003, and it seems
unworkable in 2007.

- Jon
 
I tried some more things, mostly macros recorded and edited in 2003 which
work fine in 2003. When run in 2007, they generally work until the last
step, at which point the negative reverts to white. Nothing seems to be able
to retain the defined color for the negative bars, unless the gradient or
pattern is retained.

- Jon
 
I tried useing Excel 2003 creating a chart with the colors the way
that I wanted saved it as an 2003 workbook then opened it up in 2007
and the negative bar turned white. It looks like Microsoft doesn't
want anyone to use a color other that white. Thanks so much for trying
to help.
 
I tried useing Excel 2003 creating a chart with the colors the way
that I wanted saved it as an 2003 workbook then opened it up in 2007
and the negative bar turned white. It looks like Microsoft doesn't
want anyone to use a color other that white. Thanks so much for trying
to help.
 
Andy Pope has assured me that he can't figure it out either, so I think it
probably can't be done. Your note that it also doesn't work on a chart that
was successfully formatted in 2003 gives further weight to this conclusion.

John Mansfield suggested using two series, one for positive and one for
negative. Format them as desired, and set the overlap to 100, or use stacked
columns. This is a variation on conditional charts:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

- Jon
 
Back
Top