Expand Minimize

Separator Property

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

Community Additions

ADD
Show:
© 2014 Microsoft