Move Vertical Axis to the Left – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on October 30, 2023

This tutorial will demonstrate how to move the vertical axis to the left of the graph in Excel and Google Sheets.

Move Vertical Axis (Y Axis) to Left of Graph in Excel

Starting with your Data

When working with data where the X Axis has negative values in it, you’ll see that the Y Axis automatically appears in the middle of the graph. This tutorial will show how to move it to the left of the graph so that it can be seen easier to see.

Move Y Axis to Left of Graph in Excel

Moving Y Axis to the Left of the Graph

  1. Click on the Y Axis
  2. Select Format Axis

Format Y Vertical Axis to Left of Graph in Excel

3. Under Format Axis, Select Labels

4. In the box next to Label Position, switch it to Low

Y Axis Low Left Graph Excel

Final Graph

Now your Y Axis Labels are showing at the left of the graph instead of in the middle, which is clearer to see the labels.

Final Y Vertical Axis Left Excel

Move Vertical Axis to Left in Google Sheets

Unlike Excel, Google Sheets will automatically put the Y Axis values at the left of the sheet. Your graph should automatically look like the one below.

Final Y Axis Left Vertical Google Sheets

AI Formula Generator

Try for Free