Terminate lines at intersect point

  • Thread starter Thread starter Fleming_student
  • Start date Start date
F

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!
 
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
 
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
 
Back
Top