How to Move Y-Axis to Left, Right, Middle in Excel Chart

Placing your chart's Y-axis (the vertical one) seems like it should be simple, but Excel's settings can be buried. Whether you need to move it for clarity, to create a dual-axis chart, or just for a specific visual style, mastering this trick makes your charts much more flexible. This tutorial will walk you through exactly how to move your Y-axis to the right, the center, or back to the left in any Excel chart.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Would You Need to Move the Y-Axis?

Most charts default with the vertical Y-axis on the left and the horizontal X-axis on the bottom. It's a standard convention that everyone understands immediately. So why mess with a good thing? There are a few practical reasons:

• Comparing Different Data Scales: This is the most common reason. If you're plotting two different types of data on the same chart (like sales revenue in dollars and units sold as a count), their scales will be wildly different. A chart showing revenue in the millions would make the "units sold" series look like a flat line. By adding a secondary Y-axis to the right, you can plot each data set against its own scale, making both readable. We'll cover this in detail.
• Visual Emphasis: Sometimes, placing the Y-axis on the right side simply draws the viewer's eye to the endpoint of the data trend, which can be useful for showing growth over time. It can also prevent axis labels on the left from crowding the first data point.
• Showing Negative and Positive Values: If your data includes both positive and negative numbers, like profit and loss or variance from a baseline, placing the Y-axis in the middle (at the zero point of the horizontal X-axis) creates a clear visual divide between the two. This is very common in financial and variance analysis charts.

First, Let's Create a Basic Chart

Before we start moving axes, we need a chart to work with. Let's use a simple dataset showing monthly website traffic for the first half of the year. Here's our sample data:

Month | Sessions Jan | 10,500 Feb | 12,300 Mar | 11,800 Apr | 14,000 May | 15,200 Jun | 17,000

To create a basic column chart:

1. Enter this data into two columns in your Excel sheet.
2. Highlight the entire data range, including the headers (e.g., A1:B7).
3. Go to the Insert tab on the Excel ribbon.
4. In the Charts group, click the icon for "Insert Column or Bar Chart" and select the first option under 2-D Column (Clustered Column).

Excel will instantly generate a chart with the Y-axis on the left, which is our starting point.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

How to Move the Y-Axis to the Right

Moving the primary Y-axis from the default left position to the right is a straightforward formatting change. The key is in knowing that you actually format the horizontal (X-axis) to control where the vertical (Y-axis) crosses it.

Follow these steps:

1. Click on your chart to select it.
2. Right-click on the horizontal axis labels (the months: "Jan," "Feb," etc.). Do not right-click on the data columns themselves.
3. From the context menu that appears, select Format Axis...
4. The "Format Axis" pane will open on the right side of your screen. Ensure you're on the tab with the bar chart icon (labeled "Axis Options").
5. Look for the section called Vertical axis crosses.
6. By default, it's set to "Automatic." Change this by selecting the option At maximum category.

As soon as you select it, you'll see the Y-axis jump from the left side of the chart to the right. "Maximum category" simply tells Excel to place the vertical axis after the very last data category on your horizontal axis (in our case, after "Jun").

How to Move the Y-Axis Back to the Left

What if you want to switch it back? Just follow the same steps. Right-click the horizontal axis, choose Format Axis, and in the "Vertical axis crosses" section, set the option back to Automatic. You could also select At category number and type 1, which achieves the same result by placing the axis before the first category.

How to Move the Y-Axis to the Middle

Moving the axis to the middle is often used to split positive and negative values. For this technique, we'll need a different dataset that shows variance against a budget.

Department | Budget Variance Marketing | 5,000 Sales | -2,500 Engineering | 8,000 Support | -1,000 Operations | 3,200

Create a simple column chart from this data. Notice how the bars for "Sales" and "Support" go down below the zero line.

Now, let's say we want to move the axis somewhere in the middle of our chart for emphasis. We'll use a similar method as before, but with a slight tweak.

1. Create your chart with the data above.
2. Right-click the horizontal axis (the department names).
3. Select Format Axis... from the menu.
4. In the "Format Axis" pane, under "Axis Options," find the Vertical axis crosses section again.
5. This time, select At category number.
6. In the input box next to it, type a number representing the position where you want the axis to cross. The categories are numbered from left to right, starting at 1. If you want the axis to appear between "Engineering" and "Support" (the 3rd and 4th categories), you would enter the number 4. This places the axis cleanly before the fourth category begins.

You can experiment with different numbers to get the axis exactly where you need it.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Using a Secondary Y-Axis on the Right

This is arguably the most powerful and useful application of a right-hand axis. It allows you to display two different data series on the same chart, even when their value ranges are completely different.

Let's add "Units Sold" to our original monthly traffic data, creating a new dataset:

Month | Sessions | Units Sold Jan | 10,500 | 210 Feb | 12,300 | 250 Mar | 11,800 | 230 Apr | 14,000 | 310 May | 15,200 | 355 Jun | 17,000 | 400

If you plot this on a regular chart, the "Units Sold" numbers are so small compared to "Sessions" that they'll be almost invisible. The solution is a Combo Chart with a secondary axis.

1. Highlight all three columns of your data.
2. Go to the Insert tab and click the Combo chart icon (it looks like a line over a column). Select Create Custom Combo Chart... at the bottom.
3. This will open the "Insert Chart" dialog box, which gives you control over each data series.
4. You'll see rows for "Sessions" and "Units Sold." Keep "Sessions" as a Clustered Column. Change the chart type for "Units Sold" to a Line or Line with Markers. This makes it easier to visually distinguish the two datasets.
5. Now for the most important step: in the row for "Units Sold," check the box in the Secondary Axis column. A preview at the top will show you exactly what will happen.
6. Click OK.

Your chart now has two Y-axes! The primary axis on the left corresponds to the Sessions (the columns), and the new secondary axis on the right corresponds to the Units Sold (the line). Now both trends are clearly visible on the same chart.

Pro Tip: It’s good practice to color-code your axes and data series titles to match. For example, if the "Units Sold" line is orange, make the title and axis labels for the right Y-axis orange too. This makes your chart much easier for others to understand at a glance.

Common Problems and Troubleshooting

My Axis Labels Overlap the Axis Line. How Do I Fix It?

Sometimes, when you move the axis to the middle, the X-axis labels can overlap with the vertical line. To fix this, right-click the horizontal axis, choose Format Axis, expand the Labels section, and under "Label Position," try changing the setting from "Next to Axis" to "Low" or "High" to move the text away from the line.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Help! I Deleted My Y-Axis By Accident.

It happens! Click anywhere on your chart to make the three icon buttons appear on the top right. Click the plus sign (+) to open the Chart Elements menu. Simply check the box next to Axes (or expand it and check Primary Vertical or Secondary Vertical) to bring it back.

The "At Category Number" Setting Isn't Working Right.

Remember that the number you enter corresponds to the category before which the axis will be placed. If you have 5 categories and enter 5, the axis will appear before the 5th category. If you want it on the far right, you should use the At maximum category setting instead, which is effectively like entering a category number of 6 in a 5-category chart.

Final Thoughts

Knowing how to position your Y-axis in Excel is a fundamental skill that unlocks more advanced and clearer data visualizations. Whether you are creating clean dashboards, comparing data with wildly different scales, or simply fine-tuning the look and feel of your reports, controlling your axes gives you the power to tell the story you want with your data.

Once you nail these techniques in Excel, you might find yourself manually building the same reports week after week. If a lot of your reporting involves pulling data from multiple places - like Google Analytics, Shopify, and social media ads - all at once, we've designed Graphed to remove that headache. We connect to all your data sources so you can build live dashboards automatically, letting you ask questions in plain English instead of wrestling with chart settings and pivot tables. It's like having these reports build and update themselves.