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. Carl

    Links and Graphs

    Carl, Aug 18, 2004, in forum: Microsoft Excel New Users
    Replies:
    0
    Views:
    208
  2. RonCo

    spreadsheet and graphs?

    RonCo, Aug 30, 2004, in forum: Microsoft Excel New Users
    Replies:
    0
    Views:
    236
    RonCo
    Aug 30, 2004
  3. Guest

    Line graphs dropping to zero!

    Guest, Oct 15, 2004, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    1,222
    Gord Dibben
    Oct 15, 2004
  4. Guest

    graph linear Algebra equations and inequalities

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

    How do I perform linear regression?

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

    Dividing a linear goal

    TheNewGuy, Mar 13, 2008, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    220
    TheNewGuy
    Mar 13, 2008
  7. Mike
    Replies:
    9
    Views:
    2,120
    Khoshravan
    Feb 17, 2009
  8. 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:
    276
    MikeR-Oz
    Mar 28, 2009
Loading...