| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Page Orientation in Excel 2007 | Excel Discussion (Misc queries) | |||
| Pagesetup.Orientation need VBA routine to "Best Guess" Orientation | Excel Discussion (Misc queries) | |||
| Excel 2007 Landscape Orientation | Excel Discussion (Misc queries) | |||
| Excel 2007 page orientation button not working | Setting up and Configuration of Excel | |||
| Xaxis labels disappear. | Charts and Charting in Excel | |||
Hybrid Mode
