I need an acurate way of reading off an intersection point from a chart (intersection between 2 curves). Is there way of reading off the X and Y co-ordinates of the intersection as you hover the curser over the intersection point. (it is impossible to solve the 2 equations analytically)Has anyone set up a macro to do this- if at all, it's feasible?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Finding intersection point in an Excel chart
- Thread starter DonyBoy
- Start date
SkipVought
Programmer
Did you check out the link for smooth_curve_bezier_example_file.xls?
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Did you hear what happened when the OO programmer lost his library?...He's now living in OBJECT poverty!
![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]- Status