Excel VBA: Is there any way to format chart axes through VBA only?

Question

Hi,

I have to make column charts in Excel using VBA only (no user input). I wanted to format the labels of the x-axis so that the alignment for every label becomes -270 degrees. (This can be done manually by changing the "Custom angle" property in the "Alignment" tab of the "Format Axis" Dialog.) I have tried recording a macro for this but Excel does not seem to be recording the alignment step. Does anybody know how to do this with VBA only?

Answer 1

If you are using Excel 2007, try using an earlier version because 2007's macro recorder is a bit crippled.

This is what I got:

ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.Axes(xlCategory).Select
Selection.TickLabels.Orientation = xlUpward

Answer 2

What if I want another angle? Say -67? How do I tell excel to incline my x axis labels -67 degrees?

Answer 3

ActiveChart.Axes(xlCategory).TickLabels.Orientation = 67