TickLabels Object Members

  • Article
Excel Developer Reference

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

Methods

  Name Description
Bb225731.methods(en-us,office.12).gif Delete Deletes the object.
Bb225731.methods(en-us,office.12).gif Select Selects the object.

Properties

  Name Description
Bb225731.properties(en-us,office.12).gif Alignment Returns or sets a Long value that represents the alignment for the specified phonetic text or tick label.
Bb225731.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb225731.properties(en-us,office.12).gif AutoScaleFont True if the text in the object changes font size when the object size changes. The default value is True. Read/write Variant.
Bb225731.properties(en-us,office.12).gif Depth Returns a Long value that represents the number of levels of category tick labels.
Bb225731.properties(en-us,office.12).gif Font Returns a Font object that represents the font of the specified object.
Bb225731.properties(en-us,office.12).gif Format Read-only
Bb225731.properties(en-us,office.12).gif MultiLevel Read/write
Bb225731.properties(en-us,office.12).gif Name Returns a String value that represents the name of the object.
Bb225731.properties(en-us,office.12).gif NumberFormat Returns or sets a String value that represents the format code for the object.
Bb225731.properties(en-us,office.12).gif 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). Read/write Boolean.
Bb225731.properties(en-us,office.12).gif NumberFormatLocal Returns or sets a Variant value that represents the format code for the object as a string in the language of the user.
Bb225731.properties(en-us,office.12).gif 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.
Bb225731.properties(en-us,office.12).gif Orientation Returns or sets a Long value that represents the text orientation.
Bb225731.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225731.properties(en-us,office.12).gif ReadingOrder Returns or sets the reading order for the specified object. Can be one of the following constants: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext. Read/write Long.