View Single Post
  #1  
Old September 29th, 2003, 01:20 AM
Jon Peltier
external usenet poster
 
Posts: n/a
Default Terminate lines at intersect point

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Fleming_student wrote:
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!