Hi,

No need for code. See my explanation of how to get Invert if negative to
work for you.
http://www.andypope.info/charts/Invertneg.htm

Cheers
Andy

smck wrote:
I create several charts to compare various volumes of data. Presently, if the
data is negative, I manually change the color of the bars to Orange. I would
like to write a conditional statement to automate this.

Any help is greatly appreciated.

Thanks,
smck

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info