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

D

Deane

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.
 
L

Luke M

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to control aspect ratio of X,Y axes? 5
Non Linear Scatter plot, need to find y value 3
map data (x-y axis) with diffent series name 1
How do I create a curved graph in excel? 4
Displaying secondary x-coordinate information 1
Chart size relative to contents 1
Labeling on independently stacked line chart 0
Can a text box on a chart be locked to an X-Y coordinate location on the chart? 1

Top