+ Reply to Thread
Results 1 to 3 of 3

Plotting a Parallel Line to Existing Line

  1. #1
    Registered User
    Join Date
    05-07-2013
    Location
    Anchorage
    MS-Off Ver
    Excel 2007
    Posts
    42

    Plotting a Parallel Line to Existing Line

    Dear Sir:

    I have a chart with four points and a trend line is fitted through these 4 points, giving me equation of straight line. I have a 5th point at a certain distance (Point A in attached graph) from the existing trend line. How can I draw a trend line through Point A which would be parallel to the existing trend line?

    Your prompt response will be very highly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Plotting a Parallel Line to Existing Line

    Hi asifmian,

    Because you know the slope of the line and what point it goes through you can use the "Slope Point" form of the equation of the line.

    If point A has coordinates (x1,y1) and you already have the slope as .4631 you would use these to create the parallel line.

    (y - y1) = .4631(x - x1) is the answer.

    https://www.freemathhelp.com/point-slope.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    05-07-2013
    Location
    Anchorage
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: Plotting a Parallel Line to Existing Line

    Thanks a lot for the prompt response. The solution is great!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Updating existing 4 line graph is giving single line graph
    By carrach in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-15-2016, 07:53 AM
  2. Plotting a line from a specified point on Y axis to a chart line
    By enanthate in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-12-2016, 09:00 AM
  3. Replies: 2
    Last Post: 11-13-2015, 03:55 PM
  4. Drawing a parallel line to a Bezier curve
    By mdleclerc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2014, 03:17 PM
  5. Creating a parallel line to a best fit line
    By tpc123 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-05-2010, 05:53 AM
  6. Draw Parallel Line Through Scatter Plot
    By IronMan79 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-07-2009, 04:05 PM
  7. To Draw A Line Parallel To A Curve At Particular Offset
    By vijay4u in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-08-2006, 11:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1