Excel: How to Move Vertical Axis to Left of Graph


You can quickly move a horizontal axis to the bottom of a graph in Excel by modifying the Label Position value within the Format Axis panel.

The following step-by-step example shows how to do so in practice.

Related: How to Move Horizontal Axis to Bottom of Graph in Excel

Step 1: Enter the  Data

First, let’s enter the following dataset into Excel:

Step 2: Create the Graph

Next, highlight the values in the range A2:B11.

Then click the Insert tab along the top ribbon, then click the icon called Scatter within the Charts group.

The following scatter plot will appear:

By default, Excel places the vertical axis at a value of x = 0.

Step 3: Move Vertical Axis to the Left

To move the vertical axis to the left side of the graph, right click any of the values on the vertical axis, then click Format Axis from the dropdown menu:

In the Format Axis panel that appears, click the dropdown arrow next to Labels, then click the dropdown arrow next to Label Position, then click Low:

The vertical axis will be moved to the left side of the graph:

Note: If you would like to move the vertical axis to the right side of the graph instead, you can choose High from the Label Position dropdown menu.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Rotate Axis Labels in Excel
How to Change Axis Scales in Excel Plots
How to Add a Vertical Line to Charts in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *