This documentation is archived and is not being maintained.

Separator Property

Office 2003

Returns or sets the string that separates data label components in the specified series or chart. Read/write String.


expression    Required. An expression that returns a ChDataLabels object.


This example changes the data-label separator character for the specified series.

Sub FormatDataLabels()

   Dim dlDataLabels

   ' Add data labels to the first series.
   Set dlDataLabels = ChartSpace1.Charts(0).SeriesCollection(0) _

   ' Display the category name in the data labels.
   dlDataLabels.HasCategoryName = True

   ' Set the data label seperator.
   dlDataLabels.Separator = ":"

End Sub


Applies to | ChDataLabels Object