If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|