Extracting data from chart

[lbmokry]

Hi, I'm wondering how I can extract data from a non-linear line graph to be used in a calculation. The graph will be made based on user input data and the values to be obtained will not be entered, but read off the graph. Again, it is non-linear, and while it could be log-normal data, it may not be any particular function. Basically, I want the program to read off an x-value for a particular set of defined y-values.

Thanks in advance!
Lyn

 

[Derek Brown]

Hello and welcome to The Board.
Have a look at the last two entries in the "Data" section of the Index at:
http://peltiertech.com/Excel/Charts/ChartIndex.html
You can download the example workbook - it may give you some ideas.