Format axis alignment text direction

[Orongo]

Hi

I am creating several charts in my VBA program, these charts have different length on XValues. So if the XValues are to long, the chart automatically angle the titles to the width of the chart.

Now I want the titles to always have the text direction 270 degrees. I have tried, but with no effect

[...] .Axes(xlCategory).AxisTitle.Orientation = 270 [...]

Any ideas?

 

[Andrew Poulsom]

Is this what you want?

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

 

[Orongo]

Is this what you want?

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

Many thanks! It works perfectly.