TickLabels Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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

public interface class TickLabels

[System.Runtime.InteropServices.Guid("000208C9-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface TickLabels

Public Interface TickLabels

Attributes

GuidAttribute InterfaceTypeAttribute

Remarks

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.

Properties

Alignment	Returns or sets the alignment for the specified tick label.
Application	Returns an Application object that represents the Microsoft Excel application.
AutoScaleFont	True if the text in the object changes font size when the object size changes. The default value is True.
Creator	Returns a 32-bit integer that indicates the application in which this object was created.
Depth	Returns the number of levels of category tick labels.
Font	Returns a Font object that represents the font of the specified object.
Format	Returns the chart element format. Read-only.
MultiLevel	Sets whether an axis is multilevel or not. Read/write.
Name	Returns the name of the object.
NumberFormat	Returns or sets the format code for the object.
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	Returns or sets the format code for the object as a string in the language of the user.
Offset	Returns or sets the distance between the levels of labels and the distance between the first level and the axis line.
Orientation	The text orientation. Can be an integer value from –90 to 90 degrees or one of the XlTickLabelOrientation constants.
Parent	Returns the parent object for the specified object.
ReadingOrder	Returns or sets the reading order for the specified object.

Methods

Delete()	Deletes the object.
Select()	Selects the object.