Solved: Macro recorder does not record chart changes?

[macro_man]

I often use the macro recorder first but I noticed that it does not seem to show code to make the change that I want.

I simply want to modify a current chart so that the X axis formats show the alignment at a custom angle of -30 degrees (from a horizontal text direction). When recording the change I want the result is as follows:

[vba]
ActiveSheet.Shapes.AddChart.Select
ActiveChart.SetSourceData Source:=Range("'For_Graphs'!$AE$5:$AF$15")
ActiveChart.ChartType = xlColumnClustered
ActiveChart.Axes(xlCategory).Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ChartArea.Select
[/vba]

How do I write code to make this adjustment. Is there an excellent book on this subject?

I'm using Microsoft Excel 2007

Thanks.

Allen

[p45cal]

[VBA]ActiveChart.Axes(xlCategory).TickLabels.Orientation = -30
[/VBA]

[macro_man]

[vba]ActiveChart.Axes(xlCategory).TickLabels.Orientation = -30
[/vba]

Thanks very much for your help! This solved my problem.