Finding

[=?iso-8859-1?Q?Hans_Petter_H=F8ie?=]

Two curves are crossing in my scattered chart. Along the
X-axis I now can see at which X-value this crossing takes
place.
It is easy to calculate what value this is, but
can Excel report this value with some kind of function?

 

[Bernard Liengme]

Hello Hans,
You need to find the equations that fit the two curves and then so some
simple algebra. Tell us more about the curses: can they be fit to a
polynomial?

Best wishes

 

[Tushar Mehta]

Complementing Bernard's solution, see if either of the following help:

Read X and Y value of any point on a chart
http://www.tushar-mehta.com/excel/tips/read_chart_value/index.html

Interactive chart add-in
http://www.tushar-
mehta.com/excel/software/interactive_chart_display/index.html

--
Regards,

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