Velvet Star Monitor

Standout celebrity highlights with iconic style.

updates

How to move the y axis to the left in excel , scatter plot with x-axis log scale?

Writer Olivia Zamora

I have my scatter plot with x-axis log scale like below:

scatter

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.

  1. Double click on graph
  2. Double click on x-axis
  3. On the Scale tab, have the y-axis cross the x-axis at 0.1.
  4. Click OK
1

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.

1

Double 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

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy