Forum Discussion
Solved
Input X coordinate on graph and output Y coordinate?
Good Afternoon, I am trying to find a way to output the Y coordinated of a point of a graph when I input a X coordinate. Is there a function or formulae that would allow me to do this. I have tri...
Thanks. The attached version uses linear interpolation. The X is in F30 and the results in F31:F33.
I left some helper formulas in G30:H33. If you wish, you can substitute them into the formulas in F31:F33.
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
HansVogelaar Sorry for the delay. Here is a worksheet with the data and graph I am trying to work with. You help is appreciated!
Thanks. The attached version uses linear interpolation. The X is in F30 and the results in F31:F33.
I left some helper formulas in G30:H33. If you wish, you can substitute them into the formulas in F31:F33.
- Thank you so much, this is exactly what I needed