ulfal029
02-12-2008, 03:48 AM
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.
ActiveChart.SeriesCollection(1).Points(4).ApplyDataLabels AutoText:=True, ShowCategoryName:=True, _
ShowValue:=True
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:
Dim xValue As Long
xValue = ActiveChart.SeriesCollection(1).Points(4)...something
is there a way to retrieve the X and Y data label values shown for a point in a XY scatter chart? Help appreciated.
ActiveChart.SeriesCollection(1).Points(4).ApplyDataLabels AutoText:=True, ShowCategoryName:=True, _
ShowValue:=True
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:
Dim xValue As Long
xValue = ActiveChart.SeriesCollection(1).Points(4)...something