feeding data labels into excel with VBA

Question

i have a scatter plot graph

i would like each dot to have a label.

how do i feed in labels through VBA for each dot?

Answer 1

You're after the ApplyDataLabels method. Make sure you read the documentation, it has a lot of optional parameters.

Sub Example()
    Dim sc As Excel.Series
    For Each sc In Chart2.SeriesCollection
        sc.ApplyDataLabels xlDataLabelsShowValue, True, True, False, True
    Next
End Sub