Axis.AxisTitle Property (Excel)
Returns an AxisTitle object that represents the title of the specified axis. Read-only.
Syntax
expression .AxisTitle
expression A variable that represents an Axis object.
Remarks
This example adds an axis label to the category axis in Chart1.
Example
With Charts("Chart1").Axes(xlCategory)
.HasTitle = True
.AxisTitle.Text = "July Sales"
End With