Graphs in Excel

[mocmaria]

Hey,

I'm setting up an excel programme that will calculate the effort allocation in a search and rescue situation at sea. This includes a percentage known as the probability of detection (POD) which has to be read off a graph.

I want to create the same graph in excel and get my spread sheet to analyse the graph and give me the answer without looking at the hard copy of the graph.
It's hard to explain but I do not want to create a graph using the data in the spread sheet. I want the data the query the answer from the graph that I will create seperately using other data and I want the answer to appear in the spread sheet.

Is it possible?? If so....how????

 

[gardnertoo]

You will probably have to manually create an X vs Y lookup table by hand from your graph. Excel doesn't have any way that I know of for you to import an image and "read" the Y values for a given X.

 

[tusharm]

If you are creating the graph using data from some other source, why not import that data into Excel and use it there.

Hey,

I'm setting up an excel programme that will calculate the effort allocation in a search and rescue situation at sea. This includes a percentage known as the probability of detection (POD) which has to be read off a graph.

I want to create the same graph in excel and get my spread sheet to analyse the graph and give me the answer without looking at the hard copy of the graph.
It's hard to explain but I do not want to create a graph using the data in the spread sheet. I want the data the query the answer from the graph that I will create seperately using other data and I want the answer to appear in the spread sheet.

Is it possible?? If so....how????