The number of a data point in a series

Assume this:
I have plotted XY data in a chart. Call the value series 'MySeries', and assume its "SeriesCollection" number is 20.
If, in a VisualBasic macro, I do this:

Please Login or Register  to view this content.

the 84-th point in 'MySeries' in the chart on sheet 'MyGraphs' is selected.

But how do I do "the reverse"?
I.e. assume I select a point in the plot of 'MySeries' on the chart on sheet 'MyGraphs', how do I get the number in the data series 'MySeries'?
Assume the sheet "MyData" contains 3 columns:
The X-values of 'MySeries'
The Y-values of 'MySeries'
A comment to each XY pair
Let's assume I have created a button in or close to the graph area. I want the service handler to this button, in sheet "MyGraphs",
to select sheet "MyData" and the comment cell on the row where the X and Y for the selected point are.
This will require a function we could call

Please Login or Register  to view this content.

What could 'getNumberInSeries' look like?

use SelectedPoint.Name, which return something like S1P1 series index and point index.

(Andy,)

... Only that it should (certainly) be:

Please Login or Register  to view this content.

You had missed '.DataLabel".
'SeriesAndPointnumber' takes on a value like
"Text S16P211".

/dindea
Extracting the point number as an Integer is "peanuts"...

I "said too much".
The approach with "SelectedPoint.DataLabel.Name" works only when the point has a data label (SelectedPoint.HasDataLabel = True).
For a point without a data label (SelectedPoint.HasDataLabel = False) it does not work. "SelectedPoint.DataLabel.Name" results in the error "Unable to get the Name property ..."
(and SelectedPoint.DataLabel.Name = <Unable to get the Name property ...>).
So, how do I do it on a point without a data label?

"SelectedPoint.Name" yields the error "Object variable or With block variable not set".

/dindea