Changing color of negative bar when using Invert if negative

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.
 
B

Breck

That doesn't work in Excel 2007 the instructions are for Excel 2003. I
already tried it before posting this.
 
B

Breck

That doesn't work in Excel 2007 the instructions are for Excel 2003. I
already tried it before posting this.
 
J

John Mansfield

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.
 
J

Jon Peltier

I tried a handful of tricks which make this work in 2003, and it seems
unworkable in 2007.

- Jon
 
J

Jon Peltier

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
 
B

Breck

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.
 
B

Breck

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.
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top