Search "whichpoint" in this ng

Regards,
Peter T

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Jon,

Very cool. Is there a way to identify the point that is currently
selected when a macro is run,
i.e., not using the mouse click event?

Bernie


"Jon Peltier" wrote in message
...
Here's an article about chart events:

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

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


"Giff" wrote in message
...
I have an embedded chart in sheet 1 of my workbook. I am looking to
put together an event driven macro depending on which line from the
graph is clicked on.

I have read Chris Pearsons page on event procedures and ChartObject
objects (http://www.cpearson.com/excel/Events.aspx), however this does
not allow me to work from the SeriesCollection object.

I usually like to add the code I am currently using, however with this
I am at a loss and have nothing.

Giff