Extracting Data From a Chart

E

Eric

I am writing a program in Excel and I have a matrix chart or an array
(15x11). What I am looking to do is to find the y-value which corresponds to
a known x-value but the x-value is dependent upon a value entered by the user.

In other words, I have a chart with 15 sets of x-values and depending upon a
value which is entered by the user, the exact value determines which set of
x-values is used to find the corresponding y-value.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create chart with column axis 10
Scatter Chart 1
Referencing Chart Data? 1
Chart disappearing in Excel 07 but not in 03 2
How can I cross reference information in a table? 1
Is there a property to get the values for a point in a chart series? 6
Excel 2003 vs Excel 2007 #N/A in VB 4
Is there a way to draw a vertical line from a point on the chart line to the bottom of the chart 7

Top