| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
The only way to find a specific value is to use the formula. Rgs, Bou |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I do a find and replace for a cell that has multiple line. | Excel Discussion (Misc queries) | |||
| coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
| can excel find the last used line in a column and display it? | Excel Worksheet Functions | |||
| Adding line breaks by using find and replace | Excel Discussion (Misc queries) | |||
| Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Linear Mode
