who do i conditionally change bar chart colors?

[Guest]

I want to change colors of the bars in a chart based on conditions. So if
there is a negative number, i want one color. If the number is +ve, i want
another color. This is similar to conditionally formatting of cells, except
for bars.

 

[Barb Reinhardt]

You need several series to do this. Have one series for negative numbers,
and another for positive numbers. Just make sure you include ZERO in your
calculations.

 

[Jon Peltier]

Here's an illustrated example:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

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