expression.HasTitle

expression   A variable that represents an Axis object.

Remarks

An axis title is represented by an AxisTitle object.

Example

This example adds an axis label to the category axis in Chart1.

With Charts("Chart1").Axis(xlCategory)
    .HasTitle = True
    .AxisTitle.Text = "July Sales"
End With