Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a combination graph with stackedColumns+lineGraph | Charts and Charting in Excel | |||
Graph Help- 12 month graph, but only want months that have passed | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Bar graph values keep changing | Charts and Charting in Excel | |||
Graph Axes | Excel Discussion (Misc queries) |