VBA code to modify data labels in chart

Question

Could someone help me with VBA code to show all the data labels on a chart and have the data label = the Series name? I find no easy way to do this on the UI.

[Moved from  Office/Access/Windows 10/Office 365 for business]

Answer 1

I have created a stacked column chart with a data set like this

CastBedID        Mark#      Length

1                        120            450.5

1                         144            500.25

1                         117            125

2                         147              99.5

2                         119             130.2

2                          107             250

3                          745             120

The chart comes out just fine (see attached) but I would like each of the colored squares (the series) to be labeled with the Mark#. I can go to the chart properties and select each of the Series individually and click show data label and the Length value is populated but only for the one square no way to do them all. And this again is the Length (the Value) I want the Legend(Series) value on the square

Answer 2

Can you clarify the question and possibly give us an example? What's a "Series name?"