Separator Property
The Separator property returns or sets the thousands separator for labels. Returns a String.
Syntax
object.Separator
object.Separator = Separator
Parameter | Type | Description |
Separator | String | required |
Remarks
Use "" as the string for the automatic option.
Example 1
This example demonstrates how to use a period as a thousands separator.
'Declare XAxis1 as Object
Dim XAxis1 As Object
Set XAxis1 = LineGraph.Axes.Item(1)
'TickLabels
Dim TickLabels As Object
Set TickLabels = XAxis1.TickLabels
'MajorFormat
TickLabels.MajorFormat.NumericFormat = grfNumericExp
TickLabels.MajorFormat.Separator = "."
Example 2
This example shows how to return the separator string.
Debug.Print TickLabels.MajorFormat.Separator
Used by: AutoLabelFormat object