View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Tim H[_2_] Tim H[_2_] is offline
external usenet poster
 
Posts: 20
Default Conditional Shading Areas

I have a chart with two straight lines that move daily. I would like to
setup some kind of conditional formating so that 2 of the 4 quadrants that
are created from the intersecting lines are colored different colors from the
rest of the chart.

How do I setup a conditional shading formula / template so that the areas
bounded by the intersecting lines automatically color in?