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.

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

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
<JohnMansfi...@discussions.microsoft.com> 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.

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
<JohnMansfi...@discussions.microsoft.com> 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.

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
> <JohnMansfi...@discussions.microsoft.com> 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.
>
>

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" <(E-Mail Removed)> wrote in message
news:b432d593-08b0-4dfa-9fae-(E-Mail Removed)...
> 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
> <JohnMansfi...@discussions.microsoft.com> 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.
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:b432d593-08b0-4dfa-9fae-(E-Mail Removed)...
>> 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
>> <JohnMansfi...@discussions.microsoft.com> 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.
>>
>
>

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" <jonxlmv...@SPAMpeltiertech.com>
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" <jonxlmv...@SPAMpeltiertech.com> wrote in message
>
> news:(E-Mail Removed)...
>
> >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" <betuttl...@gmail.com> wrote in message
> >news:b432d593-08b0-4dfa-9fae-(E-Mail Removed)...
> >> 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
> >> <JohnMansfi...@discussions.microsoft.com> 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.

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" <jonxlmv...@SPAMpeltiertech.com>
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" <jonxlmv...@SPAMpeltiertech.com> wrote in message
>
> news:(E-Mail Removed)...
>
> >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" <betuttl...@gmail.com> wrote in message
> >news:b432d593-08b0-4dfa-9fae-(E-Mail Removed)...
> >> 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
> >> <JohnMansfi...@discussions.microsoft.com> 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.

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" <(E-Mail Removed)> wrote in message
news:e5b2136d-b54f-4c8e-9988-(E-Mail Removed)...
>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" <jonxlmv...@SPAMpeltiertech.com>
> 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" <jonxlmv...@SPAMpeltiertech.com> wrote in message
>>
>> news:(E-Mail Removed)...
>>
>> >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" <betuttl...@gmail.com> wrote in message
>> >news:b432d593-08b0-4dfa-9fae-(E-Mail Removed)...
>> >> 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
>> >> <JohnMansfi...@discussions.microsoft.com> 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.
>