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