Get Information About a Plotted Point:
http://www.geocities.com/jonpeltier/...html#PointInfo
- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______
SoCalExcel wrote:
I'm wondering if anyone knows how to use VBA to determine
the index number of an activated data series in a chart.
For example, a user clicks on a data series and, when the
VBA code is run, the code knows which series in the
seriescollection has been clicked on.
All help is greatly appreciated.