Excel - Format Axis - Angle greyed out!?


  1. soho1
    Posts : 469
    Win 7 Pro 64-bit
       New #1

    Excel - Format Axis - Angle greyed out!?


    I made a simple chart plotting economic data from 1960 to present using the year on the time axis. I want to angle the text on a 45 incline for readability.

    The Custom angle is greyed out. I can choose the Text Direction (Horizontal, Stacked, Rotate 90 degrees, Rotate 270 degrees) but I want to specify a custom angle.

    Why is the custom angle greyed out?
    Attached Thumbnails Attached Thumbnails Excel - Format Axis - Angle greyed out!?-formataxis.png  
      My Computer
    Quote Quote

  3. soho1
    Posts : 469
    Win 7 Pro 64-bit
    Thread Starter
       New #2

    RESOLVED - The angle can only be set when the direction is set to HORIZONTAL. Thanks.
      My Computer
    Quote Quote

 

  Related Discussions
Format cells in excel 2007
in Microsoft Office

I have a spreadsheet made in excel 2007. In one of the cells is a number with three zeros in front of it and one zero at the end. However it always drops the zeros and shows only the other numbers. I select the cell and click on "format cells", but there is nothing I see that will show all the...
Hi, For some reason, the numbers for the left axis are in the middle of my chart and I have highlighted the axis and reformatted to no avail. How can I change the settings so it is shown on the far left as usual? I've uploaded a jpg showing the problem. A big thanks in advance,
Hi, I know it's a basic question -- and I've been charting with Excel for a while; but now all of a sudden when I make a Line Chart with Excel 2010; the horizonital values shown are just sequential numbers of the real X values. How do I get Excel to show the actual X values on the horizonital...
LCD Viewing Angle Problem
in Hardware & Devices

Is there any way adjust the viewing angle of a LCD monitor, moving or rotating my monitor doesn't work ?
I have an new style Excel xlsx spreadsheet that I received from a customer through Email and I can open and re-save as an xlsx spreadsheet using excel 2010. I have saved it to my desktop. When I try to save it in the 97-2003 xls format. Excel then crashes right away and a window pops up. Microsoft...
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 21:26.
Find Us