Line Series Color on Graph

[Nate]

Is there a way to make a line series on a line graph change colors based on
the value of another line? I have a line graph that has 2 lines. 1 green
line representing Total Expenses and 1 line representing Total Revenue. I
would like the line representing Total Revenue to be red whenever it is below
the line representing Total Expenses and then change to blue whenever it goes
above the Total Expenses line. Is this possible?

 

[Luke M]

Check out Jon's page on conditional chart formatting:

http://peltiertech.com/Excel/Charts/format.html#CondChart

 

[Herbert Seidenberg]

Excel 2007
Conditional line segment colors.
Step chart.
With macro.
http://www.mediafire.com/file/ztz1itzogoj/01_13_10.xlsm