How to move the y axis to the left in excel , scatter plot with x-axis log scale?
I have my scatter plot with x-axis log scale like below:
I want the position of y-axis moved to the left. How can I do this?
Solution 1:
I'm doing this from memory since I don't have Excel at home.
- Double click on graph
- Double click on x-axis
- On the Scale tab, have the y-axis cross the x-axis at 0.1.
- Click OK
Solution 2:
Left click on Horizontal axis; right click and select "Format Axis...". In the options for "Vertical axis crosses" select "Axis value" and enter the horizontal axis value you want the vertical axis to be positioned at.