Excel 2007 line chart automatic category axis text rotation
Is there any way in Excel 2007 of re-enabling the automatic (best fit)
rotation feature on category values text axes after you have entered a custom angle (the simple checkbox that existed in previous versions is no longer there and the program will not allow you to remove a custom angle completely once one has been set - only to change it)? Many thanks, Boris. |
Excel 2007 line chart automatic category axis text rotation
You apparently cannot do this through the user interface, but this line of
VBA does it: ActiveChart.Axes(xlCategory, xlPrimary).TickLabels.Orientation = xlTickLabelOrientationAutomatic Select the chart. Open the VB Editor (Alt+F11), then open the Immediate Window (Ctrl+G). Paste the line above, put the cursor in the line, and press Enter. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Boris" wrote in message ... Is there any way in Excel 2007 of re-enabling the automatic (best fit) rotation feature on category values text axes after you have entered a custom angle (the simple checkbox that existed in previous versions is no longer there and the program will not allow you to remove a custom angle completely once one has been set - only to change it)? Many thanks, Boris. |
Excel 2007 line chart automatic category axis text rotation
Thanks Jon, that's very helpful. Pity they didn't just keave the simple
little tickbox that was there but this is quite straight forward so... Thanks again and best wishes, Boris. "Jon Peltier" wrote: You apparently cannot do this through the user interface, but this line of VBA does it: ActiveChart.Axes(xlCategory, xlPrimary).TickLabels.Orientation = xlTickLabelOrientationAutomatic Select the chart. Open the VB Editor (Alt+F11), then open the Immediate Window (Ctrl+G). Paste the line above, put the cursor in the line, and press Enter. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Boris" wrote in message ... Is there any way in Excel 2007 of re-enabling the automatic (best fit) rotation feature on category values text axes after you have entered a custom angle (the simple checkbox that existed in previous versions is no longer there and the program will not allow you to remove a custom angle completely once one has been set - only to change it)? Many thanks, Boris. |
All times are GMT +1. The time now is 03:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com