Axes.Item method (Excel)

Returns a single Axis object from an Axes collection.

Syntax

expression.Item (Type, AxisGroup)

expression A variable that represents an Axes object.

Parameters

Name	Required/Optional	Data type	Description
Type	Required	XlAxisType	The axis type.
AxisGroup	Optional	XlAxisGroup	The axis.

Return value

Axis

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.