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