Solved: Retrieve value from chart data label

[ulfal029]

Hi,
is there a way to retrieve the X and Y data label values shown for a point in a XY scatter chart? Help appreciated.

[vba]ActiveChart.SeriesCollection(1).Points(4).ApplyDataLabels AutoText:=True, ShowCategoryName:=True, _
ShowValue:=True[/vba]

Edit: To clarify my point; I have a XY scatter chart where some points have datalabels with the X and Y values, and I need to retrieve them by code. A guess would be something like:

[vba]Dim xValue As Long
xValue = ActiveChart.SeriesCollection(1).Points(4)...something[/vba]

[Trevor]

Is the x and y static ceils or is the value your are trying eo get dependene apon an entry in another cell?
do you have an exaple or maybe you can atearh what your working on with a more indepth description of the x and y value you are trying to obtain and is the value dependent apon an entry in another field.

[Andy Pope]

This will return the text, which you can parse using the split function in order to get x and y value.

[vba]
activechart.SeriesCollection(1).points(4).datalabel.text
[/vba]

[JonPeltier]

If you want the values themselves:

[VBA]
Dim vX As Variant
Dim vY As Variant

vX = ActiveChart.SeriesCollection(1).XValues
vY = ActiveChart.SeriesCollection(1).Values

MsgBox "X=" & vX(4) & ", Y=" & vY(4)
[/VBA]

[ulfal029]

That should do it; thank you!