Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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

© 2015 Microsoft