Change Rotation of category axis in XL 2007.

B

Beertje

Using VBA I want to change the alignment of the text of the Category axis to
"Rotate all text 270o".
Manually: right click chart category axis, select "Format Axis", select
Alignment, Click Text Direction and scroll to "Rotate all text 270o, click
close. I cannot figure out how to do this in VBA. Please advise.
Thanks.
 

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

Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
Primary Axis Position 1
Custom Angle and Alignment with VBA 1
Excel 2007 chart line width + axis labelling with VBA 6
Extending The Horiz. Axis Question ? 2
Formatting Category Axis 4
Change the structure of words? 4
Chart Rendering incorrectly in newer release of MSO 2007 12.0.6514 0

Top