View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nate Nate is offline
external usenet poster
 
Posts: 79
Default 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?