vba - Format data labels for each series in a chart

Question

I am trying to figure out an efficient way, either VBA or not, to format the data labels on a line graph I have.

The graph should present the series name at the right most data label, for each series, while the remaining data labels are blank.

Currently I just add data labels through each series, and then format each individual data label separately - but this is slow when I have series with multiple points, in addition to several series.

Any suggestions? Thanks

Answer 1

You can loop over series and in the loop you can put

With currentSeries.points.first
    .label = "lable name"
    .font  = font(...)
    ...
End With

This way you only specify one point in each series.