Excel 2007 - VBA - set xaxis orientation
 

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

Excel 2007 - VBA - set xaxis orientation
 

Hi,

Try,

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

Cheer
Andy

On 24/02/2010 15:32, QB wrote:
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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Excel 2007 - VBA - set xaxis orientation
 

Ended up finding the answer

..Axes(xlCategory).TickLabels.Orientation = 70

QB






"QB" wrote:

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