Excel 2010 Chart Left Axis is in middle of chart


  1. Posts : 24
    Win7
       #1

    Excel 2010 Chart Left Axis is in middle of chart


    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,

    / GE
    Attached Thumbnails Attached Thumbnails Excel 2010 Chart Left Axis is in middle of chart-forseven.jpg  
      My Computer


  2. Posts : 19,383
    Windows 10 Pro x64 ; Xubuntu x64
       #2

    Thats the normal default behaviour since you have both positive and negative values on the X-axis - the chart assumes you want to see the value extremes so it places the y-axis at the zero position of the x-axis.

    You can shift the Y-axis to the far left by using the format x-axis option, like this:

    Excel 2010 Chart Left Axis is in middle of chart-capture.png
      My Computer


  3. Posts : 24
    Win7
    Thread Starter
       #3

    Golden,

    You solved that so quickly after I frustrated over it for days!! Great and thanks. My biggest mistake was trying to reformat the vertical numbers rather than the horizonital number layouts.

    See how nice it looks with your suggestions:



    Cheers and thanks again,

    / GE
    Attached Thumbnails Attached Thumbnails Excel 2010 Chart Left Axis is in middle of chart-forseven2.jpg  
      My Computer


  4. Posts : 19,383
    Windows 10 Pro x64 ; Xubuntu x64
       #4

      My Computer


 

  Related Discussions
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 22:49.
Find Us