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
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 missin
Dear michael,
thanks for the solution, but it is better if you will send all this formula
in a excel sheet.
then its easy for me to understand.
Regards.
On Fri, Aug 6, 2010 at 2:10 AM, Michael Hayes wrote:
> Sudhir,
>
> I am assuming by the subject matter of your posting you need to find
> the X
@ 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???
Rega
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
