TickLabels Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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. |