Formatting Charts - X/y Axis aligment properties text direct

[robtyketto]

Greetings,

Ive been googling and using the help pages to try and find out the vba code to allow me to format charts x,y axis titles text direction.

I tried recording the macro and its doesnt generate the full code

Here's what I do in excel :-
Right click on the appropriate x or y axis title within the chart -> Format Axis -> Alignment.

Now from here I would like the vba statements to change the text direction parameter (In this particular case I want to rotate text by 270 degrees).

Can anyone help?
Im using excel 2007 btw

Thanks
Rob

 

[pgc01]

Hi Rob

For ex., for the X-Axis. Assuming you'll want to change other properties as well, I'd structure the code like this

    With Worksheets("Sheet1").ChartObjects("Chart 1").Chart
        With .Axes(xlCategory)
            .TickLabels.Orientation = -90
        End With
    End With