Changing color of negative bar when using Invert if negative
 

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.

Changing color of negative bar when using Invert if negative
 

You will need to adjust the fill effects for the series. Andy Pope describes
the process in detail of how to do so via the link below:

http://www.andypope.info/charts/Invertneg.htm

--
John Mansfield
cellmatrix.net


"Breck" wrote:

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.

Changing color of negative bar when using Invert if negative
 

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

On Mar 1, 10:23 am, John Mansfield
wrote:
You will need to adjust the fill effects for the series. Andy Pope describes
the process in detail of how to do so via the link below:

http://www.andypope.info/charts/Invertneg.htm

--
John Mansfield
cellmatrix.net

"Breck" wrote:
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.

Changing color of negative bar when using Invert if negative
 

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

On Mar 1, 10:23 am, John Mansfield
wrote:
You will need to adjust the fill effects for the series. Andy Pope describes
the process in detail of how to do so via the link below:

http://www.andypope.info/charts/Invertneg.htm

--
John Mansfield
cellmatrix.net

"Breck" wrote:
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.

Changing color of negative bar when using Invert if negative
 

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.

--
John Mansfield
cellmatrix.net


"Breck" wrote:

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

On Mar 1, 10:23 am, John Mansfield
wrote:
You will need to adjust the fill effects for the series. Andy Pope describes
the process in detail of how to do so via the link below:

http://www.andypope.info/charts/Invertneg.htm

--
John Mansfield
cellmatrix.net

"Breck" wrote:
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.

Changing color of negative bar when using Invert if negative
 

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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

On Mar 1, 10:23 am, John Mansfield
wrote:
You will need to adjust the fill effects for the series. Andy Pope
describes
the process in detail of how to do so via the link below:

http://www.andypope.info/charts/Invertneg.htm

--
John Mansfield
cellmatrix.net

"Breck" wrote:
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.

Changing color of negative bar when using Invert if negative
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jon Peltier" wrote in message
...
I tried a handful of tricks which make this work in 2003, and it seems
unworkable in 2007.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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

On Mar 1, 10:23 am, John Mansfield
wrote:
You will need to adjust the fill effects for the series. Andy Pope
describes
the process in detail of how to do so via the link below:

http://www.andypope.info/charts/Invertneg.htm

--
John Mansfield
cellmatrix.net

"Breck" wrote:
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.

Changing color of negative bar when using Invert if negative
 

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.


On Mar 2, 4:13 pm, "Jon Peltier"
wrote:
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

"Jon Peltier" wrote in message

...

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

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

On Mar 1, 10:23 am, John Mansfield
wrote:
You will need to adjust the fill effects for the series. Andy Pope
describes
the process in detail of how to do so via the link below:

http://www.andypope.info/charts/Invertneg.htm

--
John Mansfield
cellmatrix.net

"Breck" wrote:
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.

Changing color of negative bar when using Invert if negative
 

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.


On Mar 2, 4:13 pm, "Jon Peltier"
wrote:
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

"Jon Peltier" wrote in message

...

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

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

On Mar 1, 10:23 am, John Mansfield
wrote:
You will need to adjust the fill effects for the series. Andy Pope
describes
the process in detail of how to do so via the link below:

http://www.andypope.info/charts/Invertneg.htm

--
John Mansfield
cellmatrix.net

"Breck" wrote:
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.

Changing color of negative bar when using Invert if negative
 

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/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Breck" wrote in message
...
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.


On Mar 2, 4:13 pm, "Jon Peltier"
wrote:
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

"Jon Peltier" wrote in message

...

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

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

On Mar 1, 10:23 am, John Mansfield
wrote:
You will need to adjust the fill effects for the series. Andy Pope
describes
the process in detail of how to do so via the link below:

http://www.andypope.info/charts/Invertneg.htm

--
John Mansfield
cellmatrix.net

"Breck" wrote:
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.