Item Method (Axes Collection)

Applies To

Axes collection object.

Description

Returns a single Axis object from an Axes collection.

Syntax

expression.Item(Type, AxisGroup)

expression Required. An expression that returns an Axes object.

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

AxisGroup Optional Variant. The axis group. Can be one of the following XlAxisGroup constants: xlPrimary or xlSecondary. The default value is xlPrimary.

Example

This example sets the title text for the category axis on Chart1.

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