Axes.Item method (Excel)
Returns a single Axis object from an Axes collection.
expression.Item (Type, AxisGroup)
expression A variable that represents an Axes object.
Name | Required/Optional | Data type | Description |
---|---|---|---|
Type | Required | XlAxisType | The axis type. |
AxisGroup | Optional | XlAxisGroup | The axis. |
Axis
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
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.