Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
lsu-i-like
 
Posts: n/a
Default getting a y-value from a graph knowing the corresponding x-value


if you have a graph with three points plotted [(x1,y1),(x2,y2),(x3,y3)],
can excel find y4 if you know the corresponding x4?


--
lsu-i-like
------------------------------------------------------------------------
lsu-i-like's Profile: http://www.excelforum.com/member.php...o&userid=14317
View this thread: http://www.excelforum.com/showthread...hreadid=392733

  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

You could use FORECAST() or TREND() to predict the y-value assuming that
the points can be approximated by a straight line. You could use
FORECAST() to predict the y-value assuming that the points can be
approximated by a quadratic.

Jerry

lsu-i-like wrote:

if you have a graph with three points plotted [(x1,y1),(x2,y2),(x3,y3)],
can excel find y4 if you know the corresponding x4?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a combination graph with stackedColumns+lineGraph ChartQuestion Charts and Charting in Excel 1 June 14th 05 12:39 PM
Graph Help- 12 month graph, but only want months that have passed coal_miner Charts and Charting in Excel 4 June 3rd 05 03:03 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Bar graph values keep changing Mike82j2000 Charts and Charting in Excel 1 January 6th 05 01:27 PM
Graph Axes Robin Excel Discussion (Misc queries) 0 December 8th 04 08:03 PM


All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"