View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default calculate a point

On 01/07/2011 17:30, Curbie wrote:
I'm trying to calculate some steps or stages for a graph and am having
trouble, basically I'm trying to calculate a line between a point x,y
to a point on a line between x1,y1 and x2,y2 that looks some like
this:

.x2,y2(8,6)
/
/-----------------------------------x,y(13,3)
/
.x1,y1(1,1)

I think I got the slope 5/7=0.7142857, but I'm looking for the
equation to calculate line between a point x,y to a point on a line
between x1,y1 and x2,y.

Go easy on me, I haven't been to school in 35 years.


If you mean to a point half way between x1,y1 and x2,y2, that point is
at (x1+x2)/2, (y1+y2)/2, or at 4.5, 3.5.

If, on the other hand, you mean your line to be horizontal, i.e. y=3,
then your point would have an x value of x1+(x2-x1)*y/(y2-y1), or 1+7*3/5.

David Biddulph