How to get different Shades in One Excel Chart

[excelpunk]

Hello Evryone, I have a small issue here, probably some1 can come to rescue!

OK, I have a Excel graph (Dynamic), it has two plots: 1. Area Plot 2: Line plot

I now have a intersection area as and when these two plots coincide, how can I get different colors for different areas.

For Example: Lets say I have a right angle triangle (X Axis, Y axis are its perpendicular sides and lets say there is a hypotenuse in first quadrant, I now have a line (Curve) which cuts the triangle in two parts, Is it possible to have different shades for two different areas of the triangle?

PS: The position of the line (Curve) is dynamic, so I think we need to use some macro to detect if there is a cut, if it is, then we need to give two different colors to the two parts of the triangle. I hope i have given adequate info about my problem!

 

[Steve=True]

best way to do this without VBA would be to create 6 lines of the triangle that overlapp the same space.

3 lines for black color
3 lines for red color

plot all six lines but put a formula for =NA() for the color that should not be shown.

if no intersection occurs then all lines will show up as black and red lines all =na()

if an intersection occurs on bottom most line, then that equals red value and the black line = na()

here is a good example of the na() used in a line chart to highlight one point.
http://chandoo.org/wp/2010/11/11/highlight-data-points-scatter-line-charts/