#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
intersection of two lines defined by points Leslie Excel Worksheet Functions 7 November 15th 07 08:16 PM
Intersection help Ray Excel Discussion (Misc queries) 3 September 5th 07 04:15 PM
Intersection Jithu Excel Discussion (Misc queries) 5 August 2nd 07 08:12 AM
How do I round border intersection points (vs. 90 degree angles)? BrandonG Excel Discussion (Misc queries) 1 July 2nd 07 11:27 PM
How do I find points on a curve between known points? Cybertori Excel Worksheet Functions 1 August 30th 06 07:57 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"