Class TickLabels (Excel VBA)

The class TickLabels represents the tick-mark labels associated with tick marks on a chart axis.

The classes Axis and ChartGroup. give access to class TickLabels

Member in collection

Item

To use a TickLabels class variable it first needs to be instantiated, for example

Dim tls as TickLabels
Set tls = ActiveChart.Axes(1).TickLabels

The following procedures can be used to set variables of type TickLabels: Axis.TickLabels and ChartGroup.RadarAxisLabels.

Delete - Deletes the object.

Select - Selects the object.

Properties

Alignment returns or sets a Long value that represents the alignment for the specified phonetic text or tick label.

Depth returns a Long value that represents the number of levels of category tick labels.

Font returns a Font object that represents the font of the specified object.

Format returns the ChartFormat object.

MultiLevel sets whether an axis is multilevel.

Name returns a String value that represents the name of the object.

NumberFormat returns or sets a String value that represents the format code for the object.

NumberFormatLinked true if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells).

NumberFormatLocal returns or sets a value that represents the format code for the object as a string in the language of the user.

Offset returns or sets a Long value that represents the distance between the levels of labels, and the distance between the first level and the axis line.

Orientation returns or sets a Long value that represents the text orientation.

ReadingOrder returns or sets the reading order for the specified object. Can be one of the following XlReadingOrder constants: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext.

ChartFormat - Provides access to the Office Art formatting for chart elements.

Font - Contains the font attributes (font name, font size, color, and so on) for an object.