Excel 2007 line chart automatic category axis text rotation

  • Thread starter Thread starter Boris
  • Start date Start date
B

Boris

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.
 
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
 
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.
 
Back
Top