On Wed, 2 May 2007, in microsoft.public.excel.charting,
Smylegirl said:
I have a graph of some data points and I was pretty sure that I should be
able to run my mouse along the line and wherever I stopped it would show me
the x,y coordinates. But instead I just get (series 1, 10) or something as
unhelpful as that depending on there I am on the line.

You're using the "Line" chart type, in which your "x coordinates" are
just being strung out in a row like bottles on a shelf. You would have
got into difficulties if you used that as your graphical display of your
lab results. Try changing the chart type to "XY (Scatter)", and trying
again. Your mouse should report something like "Series 1 (3,10)" instead
of "Series 1 Value: 10)", which is what you get with the line chart. The
chart will now show the lab results in their proper proportions.

I really need this data for a chemistry lab I am doing and I would
appreciate any help possible.

Now the bad news. All you'll get with this solution I propose is the
same data values you typed in, when you hover over the data points. You
won't get interpolated values by hovering over the connecting lines. For
that you should, as Bernard says, use the spreadsheet cells and some
arithmetic to calculate a model of how you think the chemical system is
behaving. Using the model, you can then "predict" what y should be for
each value of x.

Or you could just print the graph out on paper and do what we old people
used to do before they had computers, and use a ruler and pencil to draw
the lines and find the values :-)

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.