TickLabels TickLabels TickLabels Interface


Represents the tick mark labels associated with tick marks on a chart axis.

public interface class TickLabels
public interface TickLabels
Public Interface TickLabels


This object isn’t a collection. There’s no object that represents a single tick mark label; you must return all the tick mark labels as a unit. Tick mark label text for the category axis comes from the name of the associated category in the chart. The default tick mark label text for the category axis is the number that indicates the position of the category relative to the left end of this axis. To change the number of unlabeled tick marks between tick mark labels, you must change the TickLabelSpacing property for the category axis. Tick mark label text for the value axis is calculated based on the MajorUnit, MinimumScale, and MaximumScale properties of the value axis. To change the tick mark label text for the value axis, you must change the values of these properties.

Use the TickLabels property to return the TickLabels object.


Alignment Alignment Alignment

Returns or sets the alignment for the specified tick label.

Application Application Application

Returns an Application object that represents the Microsoft Excel application.

AutoScaleFont AutoScaleFont AutoScaleFont

True if the text in the object changes font size when the object size changes. The default value is True.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created.

Depth Depth Depth

Returns the number of levels of category tick labels.

Font Font Font

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

Format Format Format

Returns the chart element format. Read-only.

MultiLevel MultiLevel MultiLevel

Sets whether an axis is multilevel or not. Read/write.

Name Name Name

Returns the name of the object.

NumberFormat NumberFormat NumberFormat

Returns or sets the format code for the object.

NumberFormatLinked NumberFormatLinked 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 NumberFormatLocal NumberFormatLocal

Returns or sets the format code for the object as a string in the language of the user.

Offset Offset Offset

Returns or sets the distance between the levels of labels and the distance between the first level and the axis line.

Orientation Orientation Orientation

The text orientation. Can be an integer value from –90 to 90 degrees or one of the XlTickLabelOrientation constants.

Parent Parent Parent

Returns the parent object for the specified object.

ReadingOrder ReadingOrder ReadingOrder

Returns or sets the reading order for the specified object.


Delete() Delete() Delete()

Deletes the object.

Select() Select() Select()

Selects the object.

Applies to