tinterception point from a grahp in Excel

B

Bernard Liengme

Tell us more: are the lines linear?
In general, find equations of best fit and solve for x.
best wishes
 
J

Jerry W. Lewis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top