The charts are on a worksheet. I would like the event to run when the user
clicks on a series label (like trying to change the text in the label).

--
Thanks,
Mike


"Peter T" wrote:

Is that for a chart-sheet or embedded chart. If the latter, do you want to
trap the selection event of just one chart or all charts on a sheet or all
in a workbook.

Regards,
Peter T


"Mike Archer" wrote in message
...
Hello. Is there a way to get the name or index of a series collection
that
has been clicked?
Something like:
MsgBox ActiveChart.SeriesCollection.Selected.Name
or
MsgBox ActiveChart.SeriesCollection.Selected.Index

Of course, those examples don't work.

Thanks,
Mike