Excel Marco - Series Line colouring

[johnball96]

Unfortunately i have never done anything like this before so please treat me like an idiot!

I have this series of data which i have simply entered into a line graph. However, if possible, i would like to write a piece of code or so that the line changes colour and is red when the value is positive and blue when negative.

Jan-98 2.5
Feb-98 2.788
Mar-98 2.765
Apr-98 2.67
May-98 2.148
Jun-98 1.14
Jul-98 0.251
Aug-98 -0.419
Sep-98 -0.661
Oct-98 -0.845
Nov-98 -1.153
Dec-98 -0.976
Jan-99 -1.109
Feb-99 -1.219
Mar-99 -1.043
Apr-99 -1.026
May-99 -0.727
Jun-99 -0.434
Jul-99 -0.492
Aug-99 -0.786
Sep-99 -0.996
Oct-99 -1.006
Nov-99 -1.065
Dec-99 -1.196

i am using excel 2010.

Thank you in advance

 

[VoG]

This may help http://www.andypope.info/charts/conditionalline2.htm

Also see Conditional Charts http://peltiertech.com/Excel/Charts/ChartIndex.html#C