Bar Chart colors less than zero

[ORLANDO VAZQUEZ]

Is there a way to change the color of the bars that fall below zero axis
line, ie y values greater than zero should be blue, less than zero should be
red.

 

[Jon Peltier]

See this tutorial:

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

- Jon

 

[ORLANDO VAZQUEZ]

This answers it perfectly. Thank you!