Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I extract data from graph (i.e. interpolaton)
If we have a table of data values, can we build a graph and extract values
from it not found in the table? Example pairs 2200, 1,21; 2400, 1.37 are in table from which a (non-linear) graph is created. Is there any simple way to find the value that goes with 2217, for example? I know we can use match and index and do linear interpolation, but is there a simpler or more elegant way to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I extract data from graph (i.e. interpolaton)
FORECAST() both forecasts and interpolates:
In A1:B2 put: 2200 1.21 2400 1.37 anywhere else put =FORECAST(2217,B1:B2,A1:A2) and you will see: 1.22360 -- Gary's Student "TauBrewer" wrote: If we have a table of data values, can we build a graph and extract values from it not found in the table? Example pairs 2200, 1,21; 2400, 1.37 are in table from which a (non-linear) graph is created. Is there any simple way to find the value that goes with 2217, for example? I know we can use match and index and do linear interpolation, but is there a simpler or more elegant way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data extract from access query | Excel Discussion (Misc queries) | |||
Data Table - Graph Links Breaking!!! | Charts and Charting in Excel | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |