Extracting Data From Excel Charts

[hytham Ahmed]

I have drawn a chart in excel using tabled values and these values of course were the coordinates by which the graph was drawn. But each certain series on points represent a certain thing called "ρ" (Refer to the attached picture to understand). Then i want to enter the graph with certain coordinates (which is the red point in the attached picture). I want to make excel (for the example in the attached picture) to get me that the ρ=5.5 as it is approximately between the curve of ρ=5 and ρ=6. How to make excel understand and extract the 5.5 value ?

 

[Macropod]

Cross-posted at: https://www.excelforum.com/excel-general/1239589-extracting-data-from-excel-charts.html
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html