plot > 0 as green and < 0 as red

[stef]

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!

 

[Jon Peltier]

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

http://peltiertech.com/Excel/ChartsHowTo/InvertIfNegative.html

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

- Jon

 

[Andy Pope]

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

 

[stef]

Thanks, Andy. Will definitely look into it.

 

[stef]

Great. Thanks again!

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

http://peltiertech.com/Excel/ChartsHowTo/InvertIfNegative.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
_______