using linear / non linear graphs to extract results

Ebodski
Guest
Posts: n/a

 2nd Mar 2004
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
Guest
Posts: n/a

 3rd Mar 2004
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\$(E-Mail Removed)...
> 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
>
>
>
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Statistical interest Microsoft Excel Misc 2 7th Feb 2008 12:01 AM windsurferLA Microsoft Excel Discussion 4 24th Oct 2007 08:12 PM =?Utf-8?B?dG1hc29uNjg=?= Microsoft Excel Charting 2 19th Oct 2007 04:09 PM Mozam.ali@asterand.com Microsoft Excel Charting 3 7th Aug 2006 02:29 PM chris Microsoft Excel Charting 9 20th Jun 2006 03:11 AM

Features