Axis Interval Values Displaced

**jwcane** · 01-01-2012, 09:40 PM

After converting my chart to log y axis, Excel moved the axis to the right border and placed the grid interval numbers to the right of the axis. I need to retain that axis on the left side. On the x axis formatting dialog I specified that the y axis should cross at the minimum, i.e., left end of the x axis.When I did that, the y axis shifted to the left but the interval numbers are still to the right of the axis.I want them to be on the left as is standard with all charts.

Could you please show me how to get that done.

**Andy Pope** · 01-02-2012, 08:23 AM

Can you post example file to illustrate your chart problem

**jwcane** · 01-02-2012, 05:01 PM

OK here is the problem chart (ChartTest.xlsx attached).

Thanks,
jwxc

**Andy Pope** · 01-03-2012, 05:38 AM

Not sure if this is a Mac issue or something you did but the horizontal axis is plotted in reverse order.
So to get the vertical axis back to the left side Format the horizontal axis so it crosses vertical axis at maximum.