Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2010 Chart Left Axis is in middle of chart


19 Feb 2013   #1

Win7
 
 
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 Images
 
My System SpecsSystem Spec
.

19 Feb 2013   #2

Microsoft Community Contributor Award Recipient

Windows 7 Ult. x64 Windows 8.1 x64
 
 

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 System SpecsSystem Spec
20 Feb 2013   #3

Win7
 
 

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 Images
 
My System SpecsSystem Spec
.


20 Feb 2013   #4

Microsoft Community Contributor Award Recipient

Windows 7 Ult. x64 Windows 8.1 x64
 
 

My System SpecsSystem Spec
Reply

 Excel 2010 Chart Left Axis is in middle of chart




Thread Tools



Similar help and support threads for2: Excel 2010 Chart Left Axis is in middle of chart
Thread Forum
Can I create a pie chart with data in an existing excel file? Microsoft Office
Solved How do I see the X axis values with Excel 2010 Microsoft Office
Microsoft Excel 2010 - chart formatting question Microsoft Office
Here is an AMD Compatability Crossfire Chart Hardware & Devices
Bubble chart Microsoft Office
Non business use chart? General Discussion
Excel Line Chart Microsoft Office

Our Sites

Site Links

About Us

Find 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 06:58 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33