XY Scatter axis rotation

[sts023]

Hi Guys....

Having just converted from a line chart to an XY Scatter chart, the dates on the horizontal axis overlap.
I can manually change the orientation of the horizontal axis (to 270), but as the graph is created via VBA, I tried to record a macro whilst rotating the date text.
The recording goes as far as selecting the category axis

ActiveChart.Axes(xlCategory).Select

then records nothing else!
I tried recording selecting the X axis, rotating it, then selecting the plot area.
The recorded code shows

ActiveChart.Axes(xlCategory).Select
ActiveChart.PlotArea.Select

So does anyone know
1) how to achieve the rotation in VBA, and
2) Why the recording doesn't work?

 

[sts023]

OK, I found the answer using a Watch.

    With .Axes(xlCategory)
      .TickLabels.Orientation = xlTickLabelOrientationUpward
    End With

Other options are ~Downward, ~Horizontal, ~Automatic, and ~Vertical