Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
QB QB is offline
external usenet poster
 
Posts: 57
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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   Report Post  
Posted to microsoft.public.excel.charting
QB QB is offline
external usenet poster
 
Posts: 57
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing Page Orientation in Excel 2007 Denver Excel Discussion (Misc queries) 2 July 13th 10 11:12 AM
Pagesetup.Orientation need VBA routine to "Best Guess" Orientation [email protected] Excel Discussion (Misc queries) 3 November 10th 09 06:53 PM
Excel 2007 Landscape Orientation ExcelHUH?!?!? Excel Discussion (Misc queries) 6 August 30th 09 05:07 PM
Excel 2007 page orientation button not working ChapelHillGirl61 Setting up and Configuration of Excel 0 February 12th 09 12:51 PM
Xaxis labels disappear. Rob Charts and Charting in Excel 1 September 9th 07 01:33 AM


All times are GMT +1. The time now is 01:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"