DataLabel.Separator Property (Word)
Returns or sets the separator used for the data labels on a chart. Read/write Variant.
Version Information
Version Added: Word 2007
Syntax
expression .Separator
expression A variable that represents a DataLabel object.
Remarks
If you use a string, you will get a string as the separator. If you use xlDataLabelSeparatorDefault (= 1), you will get the default data label separator, which is either a comma or a newline character, depending on the data label.
Example
The following example sets the data label separator for the first series on the first chart in the active document to a semicolon.
With ActiveDocument.InlineShapes(1)
If .HasChart Then
.Chart.SeriesCollection(1). _
DataLabels.Separator = ";"
End If
End With