Line Series Color on Graph
 

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?

Line Series Color on Graph
 

Check out Jon's page on conditional chart formatting:

http://peltiertech.com/Excel/Charts/...html#CondChart
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Nate" wrote:

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?

Line Series Color on Graph
 

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