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

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

Hello Andy, this is exactly what I needed--thank you so much for your help;
also for the link you provided.

"Andy Pope" wrote:

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