Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Find an unknown x coordinate from know y coordinate of curved line

3 views
Skip to first unread message

Deane

unread,
Nov 6, 2009, 4:41:01 PM11/6/09
to
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.

Tushar Mehta

unread,
Nov 6, 2009, 5:30:50 PM11/6/09
to
For one option see
Interactive Chart
http://www.tushar-mehta.com/excel/software/interactive_chart_display/index.html

Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins

Luke M

unread,
Nov 9, 2009, 9:11:01 AM11/9/09
to
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!*

0 new messages