# tinterception point from a grahp in Excel

1. ## tinterception point from a grahp in Excel

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

2. ## Re: tinterception point from a grahp in Excel

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

3. ## Re: tinterception point from a grahp in Excel

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"mic" <mic@discussions.microsoft.com> wrote in message
news:92483817-0F39-4B65-94EB-36232947A861@microsoft.com...
> how to find interception point from a grahp with 2 series of data in Excel

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1