AxisTitle.Text Property (Excel)
Returns or sets the text for the specified object. Read/write String.
Syntax
expression .Text
expression A variable that represents an AxisTitle object.
Example
This example sets the axis title text for the category axis in Chart1.
With Charts("Chart1").Axes(xlCategory)
.HasTitle = True
.AxisTitle.Text = "Month"
End With