TickLabels Interface

Definition

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

public interface class TickLabels
[System.Runtime.InteropServices.Guid("935D59F5-E365-4F92-B7F5-1C499A63ECA8")]
public interface TickLabels
type TickLabels = interface
Public Interface TickLabels
Attributes

Examples

Use the TickLabels property to return the TickLabels object. The following example sets the number format for the tick-mark labels on the value axis for the first chart in the active document.

<span class="label">With ActiveDocument.InlineShapes(1) 































































































































































































































































    If .HasChart Then 































































































































































































































































        .Chart.Axes(xlValue).TickLabels.NumberFormat = "0.00" 































































































































































































































































    End If 































































































































































































































































End With</span>

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 thte values of these properties.

Properties

Alignment

Returns or sets a Long value that represents the alignment for the specified phonetic text or tick label.

Application

When used without an object qualifier, this property returns an _Application object that represents the Microsoft Word 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.

AutoScaleFont

Reserved for internal use.

Creator

Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long.

Depth

Returns a Long value that represents the number of levels of category tick labels.

Font

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

Format

Returns the line, fill, and effect formatting for the object.

Read-only ChartFormat.

MultiLevel

Sets whether an axis is multilevel. Read/write Boolean.

Name

Returns a String value that represents the name of the object.

NumberFormat

Returns or sets a String value that represents 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). Read/write Boolean.

NumberFormatLocal

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

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.

Orientation

Returns or sets a Long value that represents the text orientation.

Parent

Returns the parent for the specified object. Read-only Object.

ReadingOrder

Returns or sets an XlReadingOrder constant that represents the reading order for the specified object. Read/write Long.

Methods

Delete()

Deletes the object.

Select()

Selects the object.

Applies to