Results 1 to 4 of 4

Thread: interpolating y value on a scatter graph

  1. #1

    interpolating y value on a scatter graph



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Good Day

    I have scatter in sheet "Graph" and would like to interpolate y (invert) based on x (chainage) ied n sheet "roads". The x and y for the scatter concern are from sheet 1 column c (y) and column (x). I have copied x and y into sheet 3 and tried linest, forecast and it is not giving the desired outcome. I tried using one of the x's in the array to see if it will return y, ie x=50, y=1752.38. See attached


    You assistance will be appreciated
    Attached Files Attached Files

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    773
    Articles
    0
    Excel Version
    2010
    Hello Justmcd
    My maths isnt bad but Ive never been brilliant with graphs unless they are very basic. Ive had a look and I (sort of) understand what interpolation is.
    I also read that Excel doesn't have an Interpolation function but they also explained how to create one (probably using the UDF route).

    Take a look at this link and see if its any help. Let me know how you get on.

    http://www.blueleafsoftware.com/Prod...ationExcel.php

    HTH

    Hercules

  3. #3
    Hi Hercules

    Thanks a lot with the link. It works like a charm.

    Justmcd

  4. #4
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    773
    Articles
    0
    Excel Version
    2010
    Thats great, and your welcome.
    Thanks for letting me know.

Posting Permissions

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