AJP Excel Information

Charts













 
 

Re: Intersection between a line and multiple semi circle curve

 
The curves are created using 3 xy scatter smooth line series.
The line is a xy scatter line.
The Intersect points are 3 xy scatter series with markers only. A series has been used for each circles set of possible intersect points with the line series.
The actual intersections are calculated and returned as an array using a user defined function.

 

 
 
Example file
   

Last updated 28th April 2007

 
 
  Home | Charts | VBA Code | Fun Stuff
Newsgroups | Tips | Links | What's New | Book List
Contact | About
Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007 Andy Pope