View Single Post
  #3   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

Depends on what kind of equations describe the 2 series.

If they are 2 straight lines:
y = a1 + b1*x
y = a2 + b2*x
Then you can algebraically solve to see that they intersect at
x = -(a1-a2)/(b1-b2)

For non-linear equations, use Solver.

Jerry

mic wrote:

how to find interception point from a grahp with 2 series of data in Excel