I believe arg2 is what determines which gridline. Correct?

"Jon Peltier" wrote:

> 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.
> >>
>