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.

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.


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

Here's an illustrated example:

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

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


Barb Reinhardt wrote:
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.


"Sid N" wrote in message
...

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.