Excel 2007 - VBA - set xaxis orientation

  • Thread starter Thread starter QB
  • Start date Start date
Q

QB

How can I set the xaxis to an arbitrary angle, say -70 deg using vba?

I recorded a macro to do this and it does not actually do anything??? Tried
it 3 times. I end up with the proper layout but the recorded macro does not
actually format the xaxis when run again?!

QB
 
Hi,

Try,

With ActiveChart.Axes(xlCategory).TickLabels
.Alignment = xlCenter
.Offset = 100
.ReadingOrder = xlContext
.Orientation = -70
End With

Cheer
Andy
 
Back
Top