using linear / non linear graphs to extract results

Discussion in 'Microsoft Excel New Users' started by Ebodski, Mar 2, 2004.

  1. Ebodski

    Ebodski Guest

    Hi,

    A frequent function of my job is to analyse data on graphs/charts to extract
    data for engineering data , i.e power / temperature/flowrates etc etc

    Is the a microsoft based programe i.e. Excel/Access that is capable of
    understanding data on a scaled X-Y axis that if an X value was entered in a
    cell, the programme would extract a corresponding Y value from a line on a
    graph ?
    If anyone has any woring examples of such a thing, I'd appreciate a link

    Thx
     
    Ebodski, Mar 2, 2004
    #1
    1. Advertisements

  2. Hi,
    If there is a linear relationship between X and Y use the function FORECAST
    It a power series is needed use LINEST - see example at
    www.stfx.ca/people/bliengme/ExcelTips
    For exponential curves use LOGEST

    Give us more data and we can give you more help.
    Best wishes

    Bernard




    "Ebodski" <jarvis@{spamless}fsmail.net> wrote in message
    news:3S51c.3848$...
    > Hi,
    >
    > A frequent function of my job is to analyse data on graphs/charts to

    extract
    > data for engineering data , i.e power / temperature/flowrates etc etc
    >
    > Is the a microsoft based programe i.e. Excel/Access that is capable of
    > understanding data on a scaled X-Y axis that if an X value was entered in

    a
    > cell, the programme would extract a corresponding Y value from a line on a
    > graph ?
    > If anyone has any woring examples of such a thing, I'd appreciate a link
    >
    > Thx
    >
    >
    >
    >
     
    Bernard V Liengme, Mar 3, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    graph linear Algebra equations and inequalities

    Guest, May 17, 2005, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    545
    Bernard Liengme
    May 18, 2005
  2. Guest

    How do I perform linear regression?

    Guest, Dec 8, 2005, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    190
    Tushar Mehta
    Dec 8, 2005
  3. TheNewGuy

    Dividing a linear goal

    TheNewGuy, Mar 13, 2008, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    159
    TheNewGuy
    Mar 13, 2008
  4. Mike
    Replies:
    9
    Views:
    1,624
    Khoshravan
    Feb 17, 2009
  5. MikeR-Oz

    After IF formulae - how to extract results into other sheet?

    MikeR-Oz, Mar 28, 2009, in forum: Microsoft Excel New Users
    Replies:
    4
    Views:
    216
    MikeR-Oz
    Mar 28, 2009
Loading...

Share This Page