Axes Collection Object

Description

A collection of all the Axis objects in the specified chart.

Accessors

Use the Axes method with an argument to access a single member of the collection or without an argument to access the entire collection at once. Unlike most collections, the Axes collection is indexed using constants. Secondary axes, if present, are accessed using an additional argument. For more information, see the Axes method.

The following example uses the Axes method with an argument to set the category axis title text on the chart sheet named "Chart1."


With Charts("chart1").Axes(xlCategory)
    .HasTitle = True
    .AxisTitle.Caption = "1994"
End With

Properties

Application Property, Count Property, Creator Property, Parent Property.

Methods

Item Method.