Axis.TickLabels Property (Excel)

Published: July 16, 2012

Returns a TickLabels object that represents the tick-mark labels for the specified axis. Read-only.

expression .TickLabels

expression A variable that represents an Axis object.

This example sets the color of the tick-mark label font for the value axis in Chart1.

Charts("Chart1").Axes(xlValue).TickLabels.Font.ColorIndex = 3

Community Additions

© 2014 Microsoft