Change Rotation of category axis in XL 2007.

Beertje

Guest

Posts: n/a

26th Nov 2007

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.

« Programmatically set checkbox values on worsheet | Excel Add-In and Data cache »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change Value axis to category axis	Ronnie	Microsoft Excel Charting	1	1st May 2009 11:14 PM
Excel 2007 line chart automatic category axis text rotation	Boris	Microsoft Excel Charting	2	4th Dec 2008 11:56 PM
How do I change where category x axis crosses the 2nd y axis?	epu	Microsoft Excel Charting	7	28th Oct 2008 02:31 PM
Change the font of Category Axis	Chirag	Microsoft Excel Charting	1	23rd Jul 2004 07:30 PM
Re: How to change the order in category axis (X)?	Jon Peltier	Microsoft Excel Charting	0	24th Jun 2004 09:12 PM