Automate bar chart color based on value postive or negative

Is there way to automate a bar chart color based on value postive or
negative. for example if the value is postive change the bar chart color to
green, if the value is negative change the bar chart color to red.

Hi,

I have some instructions on how to get the invert if negative option to
work as expected.
http://www.andypope.info/charts/Invertneg.htm

Cheers
Andy

kathy wrote:
> Is there way to automate a bar chart color based on value postive or
> negative. for example if the value is postive change the bar chart color to
> green, if the value is negative change the bar chart color to red.

--

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