It's not a native Excel feature, but if you're clever, you can probably
work it out. You need to determine which gridline was clicked, then go
through each series to find line segments that cross this value, and
interpolate the Y value at the time in question (unless you happen to
have actual data points for each series at this time value).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Chip wrote:

Great articles. My question relates to gridlines. Can I click a gridline and
get all the datapoints that intersect that gridline. My chart will have time
as the x-axis with many elements graphed as lines. I would like to display
the values of all elements at a given time represented by the gridline.

"Jon Peltier" wrote:


Chris -

You can trap events in the chart. I wrote an article about this:

http://www.computorcompanion.com/LPMArticle.asp?ID=221

and I have a couple examples showing how to get values by clicking on a
plotted point:

http://peltiertech.com/Excel/Charts/...html#PointInfo

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Chris Manning wrote:


Is it possible to get the graph coordinates (i.e. the y coordinate of a
graph) in Excel using Visual Basic coding (or other methods) and insert them
into another cell? Specifically ,what I want to do is have the user click on
a graph, and have the y-coordinate at the time of the click entered into a
cell, or, alternatively, have the user click and drag across the graph and
have the coordinates at the beginning click and at the end of the drag
entered into two seperate cells. Further, the complete set of y-coordinates
is a column of data points, not a fcn if that helps at all.