How to move the y axis to the left in excel , scatter plot with x-axis log scale?
Olivia Zamora
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?
3 Answers
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
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.
1Double click on graph Double click on x-axis On the Scale tab, have the y-axis cross the x-axis at MAXIMUM CATEGORY. Click OK
1