ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   intersection points (https://www.excelbanter.com/excel-discussion-misc-queries/208486-intersection-points.html)

tinga

intersection points
 
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

intersection points
 
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?


tinga

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?



All times are GMT +1. The time now is 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com