Terminate lines at intersect point

[Fleming_student]

I’m working on charting some data and I need some help on how to make
two lines terminate where they eventually intersect. I want the lines
to appear on the left side of the screen until they intersect, then the
points that follow to the right of the intersect should not be
graphed.

I have a good knowledge of programming (although not VBA), so if that
knowledge is needed in the explanation, feel free.

Thank you VERY much for your help!

 

[Jon Peltier]

Andy Pope (http://andypope.info) has an example on his web site that
shows how to color a line differently when it is above and below an
intersection with another line. You could adopt this technique, keeping
in mind that not showing a line is basically the same as showing it in a
different color.

- Jon

 

[Tushar Mehta]

If you know the equation of the lines, solve for the intersection
point. Now, plot the lines for x=0 to x={solved value}, with the
corresponding y values.

Even if you don't know the equations, plot them, find the intersection
from the chart (this will require some trial and error), and then do
the above.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions