Determining Chart Series Number using VBA

  • Thread starter Thread starter SoCalExcel
  • Start date Start date
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selected series in chart 2
SeriesCollection(2).Formula returns formula for series 1 1
Help: Chart & data 1
Chart - Variable Series Collection 3
iterate through chart series collection 8
.Seriescolection(n).formula - size limitation? 5
Delete chart series 2
VBA Code to move DataLables to top of Chart 4

Back
Top