TickLabels Object

Description

Represents the tick-mark labels associated with tick marks on a chart axis. There is no single TickLabel object; you must access all of the tick-mark labels at once.

Tick-mark label text for the category (x) axis comes from the name of the associated category in the chart. The default tick-mark label text for the category (x) axis is the number indicating the position of the category from the left. To change the number of unlabelled tick marks between tick-mark labels, you must change the TickLabelSpacing property for the category (x) axis.

Tick-mark label text for the value (y) axis is calculated based on the MajorUnit, MinimumScale, and MaximumScale properties of the value (y) axis. You must change the values of these properties to change the tick-mark label text for the value (y) axis.

Accessors

Use the TickLabels property to return the tick-mark labels for an axis. The following example sets the number format for the tick-mark labels on the value (y) axis in embedded chart one on the worksheet named "Sheet1."


Worksheets("sheet1").ChartObjects(1).Chart _
    .Axes(xlValue).TickLabels.NumberFormat = "0.00"

Properties

Application Property, Creator Property, Font Property, Name Property, NumberFormat Property, NumberFormatLinked Property, Orientation Property, Parent Property.

Methods

Delete Method, Select Method.