If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Find an unknown x coordinate from know y coordinate of curved line
I have drawn a number of (x,y) charts and i was wondering if there is a way
of locating an unknown x coordinate with a known y coordinate directly without having to manually interpolate the data. |
#2
|
|||
|
|||
Find an unknown x coordinate from know y coordinate of curved line
For one option see
Interactive Chart http://www.tushar-mehta.com/excel/so...lay/index.html On Fri, 6 Nov 2009 13:41:01 -0800, Deane wrote: I have drawn a number of (x,y) charts and i was wondering if there is a way of locating an unknown x coordinate with a known y coordinate directly without having to manually interpolate the data. Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins |
#3
|
|||
|
|||
Find an unknown x coordinate from know y coordinate of curved line
Check out the TREND function in XL help. For your case, swap the known x's
and known y's (as XL doesn't really care which is which, its just by definition programmed to "input x, find y") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Deane" wrote: I have drawn a number of (x,y) charts and i was wondering if there is a way of locating an unknown x coordinate with a known y coordinate directly without having to manually interpolate the data. |
Thread Tools | |
Display Modes | |
|
|