ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I find a value on a line? (https://www.excelbanter.com/charts-charting-excel/29804-how-do-i-find-value-line.html)

brendas182

How do I find a value on a line?
 
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?

Bou


The only way to find a specific value is to use the formula.

Rgs,

Bou

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

In article ,
says...
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?



All times are GMT +1. The time now is 05:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com