XY Scatter Graph Series Values

[Third_Star_From_Thyroid]

Hi,
I was wondering if there was anyway that Excel can display the X&Y values at
which seperate series intersect?

Thanks

Kieran.

 

[MartinW]

Hi Kieran,

You haven't given much information so I can't give you any
specifics, but in general terms you would do this sort of
thing by calculating the intersection seperately in the worksheet
then if you want a visual representation you plot the results
as an extra series in the chart.

HTH
Martin

 

[Bernard Liengme]

Think of two straight lines; one is y=mx+b the other is Y+MX+C
Where they intersect y=Y; so mx+b=MX+B
but x = X at intersection, so mx+b=Mx+B
Rearrange to give x = (B-b)/(m-M)
Replace x in y=mx+b by this: y=m*(B-b)/(m-M) + b
So find
m with =SLOPE(y-range1,x-range-1)
b with =INTERCEPT(y-range1,x-range-1)
M with =SLOPE(y-range2,x-range-2)
B with =INTERCEPT(y-range2,x-range-2)
Write Excel formulas to compute y and x
If these are in, say G1 and H1, then in J1 enter
="x = " & text(g1,"0.000") &" y = "&text(H1,"0.000)
On chart type =J1 and the intersection values will display on the chart
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Third_Star_From_Thyroid"

 

[Jon Peltier]

Check out this example from Andy Pope's site:

http://andypope.info/charts/intersection.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Third_Star_From_Thyroid"