Determining Chart Series Number using VBA
 

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.

Determining Chart Series Number using VBA
 

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.