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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Carl

    Links and Graphs

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

    Line graphs dropping to zero!

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

    graph linear Algebra equations and inequalities

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

    How do I perform linear regression?

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

    Dividing a linear goal

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