With myChart
.HasTitle = True
.ChartTitle.Text = "First Quarter Sales"
End With
This example sets the axis title text for the category axis.
With myChart.Axes(xlCategory)
.HasTitle = True
.AxisTitle.Text = "Month"
End With