Changing Series Color

[Guest]

The data in my series is sometime positive (> 0 ) and sometimes negative (< 0).
If there is a way to present the positive and negative data points in
different coloros

Thanks

 

[Andy Pope]

Hi,

I have an explanation of how to make use of the Invert If negative option.
http://www.andypope.info/charts/Invertneg.htm

You may also find Jon's article on conditional charts useful.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy

 

[Guest]

Thank you for the promt answer