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