This is in VBA help files:

For the X axis:

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

For the Y axis change xlCategory to xlValue, and of course, the title.


" wrote:

Hello, I am trying to find a way, to change Axis titles via VBA. But I
can only select those. Can anybody help?

Thanks in advance,
Oliver