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