+ Reply to Thread
Results 1 to 2 of 2

How to find the y-values corresponding to new x-values from a graph

  1. #1
    Registered User
    Join Date
    04-07-2016
    Location
    Southampton, England
    MS-Off Ver
    2016
    Posts
    25

    Question How to find the y-values corresponding to new x-values from a graph

    I have this data, which corresponds to x-values from 0->29.53 (in days) in intervals of 0.01 as shown on the excel spreadsheet attached, on the 1st Sheet. I have the graph plotted in the spreadsheet using scatter with lines of best fit.

    Now from the same data/graph, I need to find the Y-values for a new set of x values given in the 2nd sheet of the attachment. Does anyone know a simple way of doing this? The values still go up from 0->29.53 in intervals 0.0035 or so, but be warned they are inconsistent and skip a couple of times every so often. I have checked and seen that people have linearly interpolated, which is effective for a few data points, but as you can see there on my graph multiple trend lines so trend functions and forecast functions won't work either.

    Here's the link to the spreadsheet: https://drive.google.com/open?id=0B9...FlPRWpUWnRlS3c

    If you need more clarity on what it is I need, please don't hesitate to ask. Appreciate all help provided, Thanks in advance!

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: How to find the y-values corresponding to new x-values from a graph

    Find the equation of a line given by two nearby points and then linear extrapolate.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Might look complicated formula but principle is easy.
    You just need to fin each x1, x2, y1, y2 with INDEX/MATCH combination
    Attached Files Attached Files

+ 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. Replies: 1
    Last Post: 04-30-2014, 05:49 PM
  2. Replies: 1
    Last Post: 04-19-2013, 08:30 PM
  3. Replies: 0
    Last Post: 02-04-2013, 01:18 AM
  4. Unable to graph the desire x values on line graph..?
    By tigertan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2012, 05:04 AM
  5. Get Y values from X values for a graph in excel?
    By tds019 in forum Excel General
    Replies: 0
    Last Post: 05-26-2011, 11:45 AM
  6. [SOLVED] Find Minimum values in cyclical graph
    By Kramer1557@hotmail.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-01-2006, 08:50 AM
  7. how do i find values on a line graph in Excel?
    By sorrelponie in forum Excel General
    Replies: 1
    Last Post: 09-20-2005, 03:05 PM

Tags for this Thread

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