Edit

Axes.Item method (Excel)

  • Article

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.