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

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

On Jan 7, 4:42*pm, JLGWhiz wrote:
This is inVBAhelp files:

For the Xaxis:

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

For the YaxischangexlCategory to xlValue, and of course, thetitle.



" wrote:
Hello, I am trying to find a way, tochangeAxistitles viaVBA. But I
can only select those. Can anybody help?

Thanks in advance,
Oliver- Hide quoted text -

- Show quoted text -

Thanks, that worked,
Oliver