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.

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

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.