#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default calculate a point

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.

  #2   Report Post  
Posted to microsoft.public.excel.charting
Xt Xt is offline
external usenet poster
 
Posts: 49
Default calculate a point

On Jul 2, 4:30*am, 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.


Start from slope = (y - y1)/(x - x1) = (y2 - y1)/(x2 - x1). From this
we get the equation you want -

y = y1 + (x - x1)*(y2 - y1)/(x2 - x1). In the above case, the
equation is
y = 1 + (x - 1)*(6 - 1)/(8 - 1) or. if you really need to simplify
this y = 2/7 + 5/7*x

xt
  #3   Report Post  
Posted to microsoft.public.excel.charting
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
  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 620
Default calculate a point

On 06/07/2011 08:48, David Biddulph wrote:
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


Correction:
.... x1+(x2-x1)*(y-y1)/(y2-y1), or 1+7*2/5.

David Biddulph
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
Point Sec Protector carry Excel Discussion (Misc queries) 0 April 8th 10 11:33 AM
Data point on line is not over the point/tick in X axis... TomCat Charts and Charting in Excel 2 September 6th 07 01:36 PM
X Y Scatter With Point name on each point ? Raj Charts and Charting in Excel 3 July 27th 07 08:47 PM
How do I calculate the inflection point? rgoyan Excel Worksheet Functions 3 August 23rd 06 02:16 AM
I need more general XY point to point plotting than XY scatter in spazminator Charts and Charting in Excel 12 December 19th 05 06:00 PM


All times are GMT +1. The time now is 11:36 PM.

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"