Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line chart categoray axis labels issue - Excel 2007 | Charts and Charting in Excel | |||
y axis category labels on line graph | Excel Discussion (Misc queries) | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
label the category axis from 0 to 30, step 5 in an excel chart | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel |