If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|