Need help with VBA code for Axis Title layout Alignment

[MissaLissa]

I'm trying to change the Axis Title layout alignment to -35 degrees.

I tried this without success: ActiveChart.Axes(xlCategory).AxisTitle.HorizontalAlignment = -35

Your help is greatly appreciated.

 

[Jerry Sullivan]

Hi MissaLissa,

Try...

ActiveChart.Axes(xlCategory).AxisTitle.Orientation = -35

 

[MissaLissa]

Thanks Jerry