View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
tinga tinga is offline
external usenet poster
 
Posts: 3
Default intersection points

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

"ShaneDevenshire" wrote:

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.

--
Thanks,
Shane Devenshire


"tinga" wrote:

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?