Hi,
 
A neat little solution.
 
However the answer interpolates between the values on each side.  A  series 
based on curves will lose accuracy,
 
regards
 
Ray
 
 
In a message dated 06/08/2010 17:17:43 GMT Daylight Time,  
m99pan...@gmail.com writes:

Cell B4  isnt blank...I suggested that he put his X Axis coordinates
beginning in  cell B4. In cell B4, I said enter the number 1. In cell
C4 enter the number  2 etc. Part of the difficulty in solving the math
behind this problem is  that there were missing variables. The X axis
coordinates were missing. I  suppose you could impute the X axis
coordinates (using a count function),  but I choose not to do that.

Cell C5 may or not be blank depending on  the series of numbers in row
2 and row 3. If there is no intersection  between those series values
(C2 & C3) and the prior series values ( B2  & B3) the formula in cell
C5 will return "N/A". If there is an  intersection, then cell C5 will
not be blank.

Michael  Hayes

On Aug 5, 10:35 pm, anandydr <anand...@gmail.com>  wrote:
> @ Michael Hayes
>
> Dear Michael,
>
> I  went through the solution you sent for Mr Sudhir. Using his
>  spreadsheet I used the formula you have suggested. I got the results
>  but not the logic behind. How are we getting results even though the
>  cells B4 & C5 are blank, and what are these being used  for???
>
> Regards,
> Anand
>
> On Aug 6,  1:40 am, Michael Hayes <m99pan...@gmail.com>  wrote:
>
>
>
> > Sudhir,
>
> > I am  assuming by the subject matter of your posting you need to find
> >  the X and Y coordinates of any place on the graph where series 1 and
>  > series 2 intersect. So if I understand your request correctly,  this
> > should help
>
> > Lets put your X axis  coordinates in cells B4 through E4. So in cell B4
> > enter 1, in  cell C4 enter 2 etc.
>
> > Then starting in cell C5 put this  formula to determine if there is an
> > intersection  =IF((B2-B3)*(C2-C3)>0,"N/A",B4+(B2-B3)/((B2-C2)-(B3-C3)))
> > Copy  that formula to cells D5 and E5
>
> > That formula will tell  your X axis coordinate of intersection (if
> >  applicable)
>
> > Then in cell C6 enter this formula  =IF(C5="N/A","N/A",+B2-((B2-C2)*(C5-
> > B4))) copy that formula over  to cells  D6 and E6
>
> > That formula will tell you your  Y axis coordinate where the graphs
> > intersect (if  applicable)
>
> > Email directly if you need a copy of the  edited spreadsheet.
>
> > Michael Hayes
>
> > On  Aug 5, 9:34 am, sudhir kumar <sudhir.p...@gmail.com>  wrote:
>
> > > hi friend,
> > > i have a problem  , i made two graph in excel sheet intersecting with 
each
> > >  other. now i want to highlight the value of the intersection point.  
plze
> > > help
>
> > > --
> > >  Regards-
> > > Sudhir Kumar
> > > Design  Engineer,
> > > Conceptia Software Technologies Pvt. Ltd.
>  > > Email id-sudhir.p...@gmail.com,
>
> > >  graph.xls
> > > 29KViewDownload

--  
----------------------------------------------------------------------------
------
Some  important links for excel users:
1. Follow us on TWITTER for tips tricks  and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @  http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at  http://www.excel-macros.blogspot.com
4. Learn VBA Macros at  http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at  http://exceldailytip.blogspot.com

To post to this group, send email to  excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP  US GROW !!

We reach over 7000 subscribers worldwide and receive many  nice notes about 
the learning and support from the group.Let friends and  co-workers know 
they can subscribe to group at  
http://groups.google.com/group/excel-macros/subscribe

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Reply via email to