Home |
Search |
Today's Posts |
#1
|
|||
|
|||
tinterception point from a grahp in Excel
how to find interception point from a grahp with 2 series of data in Excel
|
#2
|
|||
|
|||
Tell us mo 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" wrote in message ... how to find interception point from a grahp with 2 series of data in Excel |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Individual labels to data point in Excel charts | Charts and Charting in Excel |