Separator property (Excel Graph)
Allows the user to set or return the separator used for the data labels on a chart. Read/write Variant.
expression.Separator
expression Required. An expression that returns one of the objects in the Applies To list.
The chart must first be active before you can access the data labels programmatically.
This example sets the data label separator for the first series on the first chart to a semi-colon.
Sub ChangeSeparator()
ActiveSheet.ChartObjects(1).Activate
ActiveChart.SeriesCollection(1) _
.DataLabels.Separator = ";"
End Sub
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.