intersection points

[tinga]

Hi everyone,

I graphed two data sets, one is a line and the other is a polynomial. they
intersect each other. can any one tell me how to find the points of
intersections and highlight them on the graph?

 

[ShaneDevenshire]

Hi,

You might look at the Solver add-in which comes with Excel. You can make a
guess near each of the intersection points and Solver might solve your
problem. Solver is a very sophistacated tool which can be very challenging.

 

[tinga]

can you explain how to use solver solver. I want the x,y values at
intersections.point.