Axes Method

         Example         Applies To

Returns an object that represents either a single axis (an Axis object, Syntax 1) or a collection of the axes on the chart (an Axes collection, Syntax 2).

Syntax 1

expression.Axes(Type, AxisGroup)

Syntax 2

expression.Axes

expression   Required. An expression that returns a Chart object.

Type   Optional Variant. Specifies the axis to return. Can be one of the following XlAxisType constants: xlValue, xlCategory, or xlSeriesAxis (xlSeriesAxis is valid only for 3-D charts).

AxisGroup   Optional Variant. Specifies the axis group. Can be one of the following XlAxisGroup constants: xlPrimary or xlSecondary. If this argument is omitted, the primary group is used. 3-D charts have only one axis group.