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.