Change Axis Title

[demusoli]

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

 

[JLGWhiz]

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.

 

[demusoli]

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.






- Show quoted text -

Thanks, that worked,
Oliver