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.


"(E-Mail Removed)" 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 <JLGW...@discussions.microsoft.com> 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.
>
>
>
> "demus...@googlemail.com" 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