color lines in excel chart

[Excel777]

color lines in excel chart

hey guys i wann to color line in excel chart with different colors
ex if line go from 2 to -1 it have a color if go from 1 to -1 it have a color


-- removed inline image ---

 

[Derek Brown]

I am not sure exactly what you are trying to do but I wonder if the Kyd Series add-in or the Kyd Axes add-in will do it for you.
It is not free - details will be found at:
http://exceluser.com/catalog2/addins/kyd-sa.htm#TrafficLight
It uses formulas to make changes to Excel charts.