Excel 2007 - VBA - set xaxis orientation

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
 
A

Andy Pope

Hi,

Try,

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

Cheer
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Axis titles Excel 2007 0
Select Text to End of Footnote 9
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
VBA - (re-) Set a Table Style 2
Finding the right style field in VBA 0
VBA for Dependents shortcut menu 0
WORD VBA Search and switch to advanced ... 1
VBA Pivot Table Error 1

Top