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.