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