Excel 2002 SP3
Win XP HE

Hi,

In a column chart, how can I make the bars/columns where corresponding
data point is positive (zero or above) plot in green (or other color)
and columns where corresponding data point is negative, plot in red (or
a different color)?
Thanks!

I was so happy when I finally figured it out that I wrote a tutorial:

http://peltiertech.com/Excel/ChartsH...fNegative.html

I haven't tried figuring it out for Excel 2007 yet, though.

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



"stef" wrote in message
...
Excel 2002 SP3
Win XP HE

Hi,

In a column chart, how can I make the bars/columns where corresponding
data point is positive (zero or above) plot in green (or other color) and
columns where corresponding data point is negative, plot in red (or a
different color)?
Thanks!

You can, with VBA code or my add-in, get the Invert If Negative to work but
you have to retain a fill pattern.
As soon as you set the fill to Solid the second color is lost.

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

You can of course use the conditional chart approach. Having a series for
Positive and Negative values.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jon Peltier" wrote in message
...
I was so happy when I finally figured it out that I wrote a tutorial:

http://peltiertech.com/Excel/ChartsH...fNegative.html

I haven't tried figuring it out for Excel 2007 yet, though.

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



"stef" wrote in message
...
Excel 2002 SP3
Win XP HE

Hi,

In a column chart, how can I make the bars/columns where corresponding
data point is positive (zero or above) plot in green (or other color) and
columns where corresponding data point is negative, plot in red (or a
different color)?
Thanks!

Thanks, Andy. Will definitely look into it.

Andy Pope wrote:
You can, with VBA code or my add-in, get the Invert If Negative to work
but you have to retain a fill pattern.
As soon as you set the fill to Solid the second color is lost.

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

You can of course use the conditional chart approach. Having a series
for Positive and Negative values.

Cheers
Andy

Great. Thanks again!

Jon Peltier wrote:
I was so happy when I finally figured it out that I wrote a tutorial:

http://peltiertech.com/Excel/ChartsH...fNegative.html

I haven't tried figuring it out for Excel 2007 yet, though.

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



"stef" wrote in message
...
Excel 2002 SP3
Win XP HE

Hi,

In a column chart, how can I make the bars/columns where corresponding
data point is positive (zero or above) plot in green (or other color) and
columns where corresponding data point is negative, plot in red (or a
different color)?
Thanks!