Class TickLabels (Excel VBA)
The class TickLabels represents the tick-mark labels associated with tick marks on a chart axis.
The following procedures in this class have been grouped together and are described on a separate theme page
These are the main methods of the TickLabels class
Delete - Deletes the object.
Select - Selects the object.
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.
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.
With Charts("Chart1").Axes(xlCategory).TickLabels If .Offset < 500 then .Offset = .Offset * 2 End If End With
Orientation returns or sets a Long value that represents the text orientation.
Parent returns the parent object for the specified object. Read-only.
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.