The number of a data point in a series

**dindea** · 10-17-2012, 06:06 AM

(Andy,)

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

Dim SelectedPoint as Point
Dim SeiesAndPointnumber As String

SelectedPoint = Selection
SeiesAndPointnumber = SelectedPoint.DataLabel.Name

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

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

**dindea** · 10-17-2012, 07:24 AM

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

**dindea** · 10-23-2012, 10:07 AM

It turned out that the problem was Excel2003. It works in Excel2010. And it is possible to get the coordinates of a point in a series without "messing with" algebra.
'SelectedPoint.Left' and 'SelectedPoint.Top' return the X and Y coordinates (N.B., the Y coordinate is counted from the top edge) of the point, in chart points.