software

Hey. I used the scatterplot to make a chart of 4 trendlines. And now I need
to get the exact intersection of each pair. The only ways I can do it is (1)
go through the data itself and find the exact intersection point - which is
very slow.. or (2) bring my mouse arrow as closet to the intersection point
on the graph and get an estimate.

Is there a way to get the exact intersection point? Perhaps by selecting the
two lines I want the intersection of .. etc?
Thank you!

Hi,

I have some information on plotting the intersecting points of lines.
www.andypope.info/charts/intersection.htm

If the lines are true chart trend lines then you will need to have a
look that these sites for information on getting trend line points.
Bernard V Liengme's www.stfx.ca/people/bliengme
Tushar Mehta's Trendline coefficients
www.tushar-mehta.com/excel/ti...efficients.htm

Cheers
Andy

akr wrote:
gt; Hey. I used the scatterplot to make a chart of 4 trendlines. And now I need
gt; to get the exact intersection of each pair. The only ways I can do it is (1)
gt; go through the data itself and find the exact intersection point - which is
gt; very slow.. or (2) bring my mouse arrow as closet to the intersection point
gt; on the graph and get an estimate.
gt;
gt; Is there a way to get the exact intersection point? Perhaps by selecting the
gt; two lines I want the intersection of .. etc?
gt; Thank you!

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

By solving equations. This will be simple if the lines are linear - tell us
more
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;akrquot; gt; wrote in message
...
gt; Hey. I used the scatterplot to make a chart of 4 trendlines. And now I
gt; need
gt; to get the exact intersection of each pair. The only ways I can do it is
gt; (1)
gt; go through the data itself and find the exact intersection point - which
gt; is
gt; very slow.. or (2) bring my mouse arrow as closet to the intersection
gt; point
gt; on the graph and get an estimate.
gt;
gt; Is there a way to get the exact intersection point? Perhaps by selecting
gt; the
gt; two lines I want the intersection of .. etc?
gt; Thank you!