How to Move Y Axis to Left/Right/Middle in Excel Chart? (2024)

The Y-axis, commonly referred to as the vertical axis, is essential for effectively showing and analysing data in charts. The Y-axis is by default positioned on the chart's left side. However, you might need to move the Y-axis to the right or even centre it, depending on your data and chart requirements.

You'll discover how to adjust the Y-axis position to meet your demands, whether you want to make room for more data series, make the chart easier to read, or provide a particular aesthetic effect. In order to better assist you in comprehending and applying these strategies, we will go over step-by-step instructions and offer visual examples. So let's dive in and discover the various ways to move the Y-axis to the left, right, or middle if you're ready to customise your Excel charts and take control of the Y-axis position.

Move Y Axis to Left/Right/Middle

Here we will format the axis to complete the task. So let us see a simple process to know how you can move the Y axis to the left, right, or middle of an Excel chart.

Step 1

Consider an Excel sheet where you have a chart similar.

First, right-click on the X axis and select Format Axis.

Right Click > Format Axis.

Step 2

Then, to move the axis to the left, change Vertical Axis Crosses to Automatic.

Step 3

If you want to move the axis to the right, change the Vertical axis cross to At Maximum.

Step 4

Now, if you want to move the axis to the middle, change the Vertical axis crosses to the At category number and give an average value.

This is how you can move the y axis to the left, right, or middle in an Excel chart.

Conclusion

In this tutorial, we have used a simple example to demonstrate how you can move the Y axis to the left, right, or middle of an Excel chart to highlight a particular set of data.