Solved Excel 2010 Chart Left Axis is in middle of chart

[gelsner]

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
:sarc:

 

[Golden]

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:

 

[gelsner]

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

 

[Golden]