How do I find a value on a line?

B

brendas182

I made a line graph of data to use as a calibration. I know the y value and I
want to find the X value. Is there a way that I find find this specifically
on the line without using a trendline formula or guessing by looking at the
gridlines?
 
T

Tushar Mehta

If you can accept piece-wise linear interpolation, see
Interactive Chart
http://www.tushar-
mehta.com/excel/software/interactive_chart_display/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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

Calculate the median value before a specified list 0
Data read from exponential graph 0
Finding asymptote equation and how to draw them in excel 0
Extrapolation of x value from the trendline of a non-linear graph 1
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Trendline Not Appearing In Chart Problem ? 0
Non Linear Scatter plot, need to find y value 3

Top