Class TickLabels (PowerPoint 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

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

Dim tls as TickLabels
Set tls = ActiveWindow.RangeFromPoint.Chart.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.


Alignment returns or sets the alignment for the specified phonetic text or tick label.

Depth returns the number of levels of category tick labels.

Font returns the font of the specified object.

Format returns the line, fill, and effect formatting for the object.

MultiLevel returns or sets a value that indicates whether an axis is multilevel.

Name returns the name of the object.

NumberFormat returns or sets 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 the format code for the object as a string in the language of the user.

Offset returns or sets the distance between the levels of labels, and the distance between the first level and the axis line.

Orientation returns or sets the text orientation.

ReadingOrder returns or sets an XlReadingOrder constant that represents the reading order for the specified object.

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

ChartFormat - Provides access to the OfficeArt formatting for chart elements.