who do i conditionally change bar chart colors?

S

Sid N

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

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