Determining Chart Series Number using VBA

S

SoCalExcel

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