How to Move the Y-Axis to the Right in Excel

To move a chart’s vertical (Y) axis to the right in Excel for Microsoft 365 on Windows, select the horizontal (X) axis, open Format Axis, and set Vertical axis crosses to At maximum category. For an XY (Scatter) chart, choose the maximum horizontal-axis value instead. This changes where the axis line meets the chart; it is different from moving the axis labels.

What You’ll Need

An Excel workbook with a chart that has a horizontal axis and a vertical axis. The instructions are for Excel for Microsoft 365 on Windows; most recent desktop versions use similar options.
Permission to edit the chart. If the worksheet is protected, you may need the password or the workbook owner’s help.

You do not need to rearrange your source data or create a second axis for the usual case. Save the workbook before making changes if you want to preserve the original chart setup.

Step-by-Step

Select the chart. Click once inside the chart so Excel displays the chart tabs on the ribbon. If the chart is embedded on a worksheet, make sure you select the chart itself rather than a cell behind it.
Select the horizontal axis. Click the category names or numbers along the bottom of the chart. In a column or line chart, this is usually the X-axis. If selecting it precisely is difficult, click the chart, open Chart Format on the ribbon, then use the Current Selection list to choose the horizontal axis. The exact axis name can vary by chart type.
Open the axis formatting options. Right-click the selected horizontal axis and choose Format Axis. Alternatively, with the axis selected, use Chart Format > Format Selection. The Format Axis pane opens, usually at the right side of the Excel window.
Find the axis crossing control. In the Format Axis pane, select Axis Options, represented by a column-chart icon. Look for the section named Vertical axis crosses. You must format the horizontal axis to find this control: formatting the vertical axis instead displays the setting for where the horizontal axis crosses it.
Set the crossing point. For a line chart or a column chart with categories along the bottom, select At maximum category. Excel moves the vertical axis to the far end of the category axis, which is normally the right edge of the plot area. The option may be presented as a radio button or a choice within the crossing controls, depending on the chart and Excel build.
Check the chart and category order. Click outside the pane and inspect the result. The vertical axis should now sit at the right side of the plotting area. If the categories run in an unexpected order, note that the first and last categories determine which end Excel treats as the maximum category. You can leave the order as it is, or adjust it if a right-side axis at the other end is what you intended.
For an XY (Scatter) chart, use the value setting. Scatter charts have numeric values on both axes rather than a category axis. Select the horizontal value axis, open Format Axis > Axis Options, and find Vertical axis crosses. Choose the option to cross at the maximum axis value, or enter the horizontal-axis maximum if Excel presents a value field. The vertical axis then crosses at the right end of the horizontal scale.
Review labels and spacing. Moving the axis line can change where numbers or category labels appear and how much room the plot occupies. If the labels are crowded or on the side you do not want, select the relevant axis and adjust its Labels settings. For a vertical axis, Label Position options can include Next to Axis, High, or Low; the available choices depend on chart type. These options change label placement, not the axis crossing point.
Save the workbook. Once the chart is readable, save your changes. To undo the adjustment immediately, press Ctrl+Z on Windows. You can also return to the same crossing control and restore its previous setting.

On Mac: Select the horizontal axis, Control-click or right-click it, and choose Format Axis. In the formatting pane, open Axis Options and change Vertical axis crosses in the same way. Ribbon labels or pane layout may differ slightly by Excel version. In Excel for the web: select the chart and look for axis formatting options in the chart formatting pane. If the crossing control is missing or the chart does not respond as expected, open the workbook in the desktop app; some chart-formatting controls can be limited or arranged differently in the web version.

Common Mistakes

Formatting the wrong axis. The setting that positions the vertical axis is found while formatting the horizontal axis. If you select the vertical axis, you will usually see a setting for where the horizontal axis crosses, which moves the X-axis up or down instead.
Changing label position and expecting the axis line to move. Label Position controls where the numbers or category names appear. It does not move the line that represents the Y-axis. Use Vertical axis crosses to move that line.
Choosing a numeric crossing value on a category chart. A line or column chart often uses categories, even if the category labels look like numbers. In that case, use At maximum category. The maximum-value option is for a numeric horizontal value axis, such as the one in a scatter chart.
Reversing the category order accidentally. The last category might appear on the left if the category order has been reversed. The right-hand endpoint may therefore not match what you expect. Check the sequence of labels before changing axis order settings.
Adding a secondary axis unnecessarily. A secondary axis creates an additional scale, often for a different data series. It is not the normal way to move the existing Y-axis to the right, and it can make a chart harder to interpret.
Expecting every chart type to behave the same way. Category charts, scatter charts, and charts with date axes have different axis controls. Use the option that matches the axis type shown in the Format Axis pane.

Tips

Use the Current Selection list when clicking is fiddly. With the chart selected, the list on Chart Format can help you select the horizontal axis even when gridlines, data labels, or plotted lines are close together.
Keep the scale easy to read. Moving the axis does not change the underlying data or scale, but it may make tick marks and labels feel less familiar. Check that the direction of increasing values is clear and that no important labels are hidden.
Check the chart after resizing it. A narrow chart may leave too little room for labels on the right. Widen the chart or reduce unnecessary label clutter rather than shrinking text until it becomes difficult to read.
Use an axis title if context matters. If moving the Y-axis could confuse readers, add or retain a clear vertical-axis title. Select the chart, then use Chart Design > Add Chart Element > Axis Titles and choose the vertical axis title option. Ribbon availability can vary with chart type.
Keep a copy before complex formatting. For a chart with several series, custom scales, or a secondary axis, duplicate the chart first. That gives you a straightforward way to compare the revised layout with the original.

Troubleshooting

The axis did not move. Confirm that you selected the horizontal axis, not a data series or the vertical axis. Reopen Format Axis, check that the pane title refers to the horizontal axis, and set Vertical axis crosses to the appropriate maximum option. If the option is absent, verify the chart type and try the desktop Excel app.

The axis moved to the left instead. Check the category order and which category Excel treats as the maximum. On a category chart, the axis moves to the maximum-category end, which can be on the left when the category order is reversed. If the chart has a numeric horizontal axis, confirm that you chose the maximum value rather than entering the minimum.

The labels moved but the axis line did not. You probably changed Label Position. Select the horizontal axis and change Vertical axis crosses instead. If the line itself is hard to see, select the vertical axis and check its line formatting; it may be set to no line or have a very light color.

The chart shows a second vertical scale. A secondary axis may have been enabled for a data series. Select that series, open its formatting options, and check whether it is plotted on the secondary axis. Remove the secondary-axis assignment if it was not intentional. Keep it only if you genuinely need a separate scale for a series with a different range.

The setting is unavailable or grayed out. Make sure the chart is selected and that you have selected an axis, not the chart area. Some chart types do not offer the same crossing controls. If you are editing in a browser, open the file in Excel for Microsoft 365 on Windows or Mac and check the axis options there. A protected worksheet or restricted workbook can also prevent edits.

Frequently Asked Questions

Can I move the Y-axis to the right without changing the data?
Yes. Changing where the axes cross changes the chart layout, not the worksheet values or series formulas. It does not reorder the source data unless you separately change the category order.

Why do I format the X-axis to move the Y-axis?
The crossing control is attached to the axis that the other axis crosses. To place the vertical axis at the right end, change the vertical-axis crossing setting while formatting the horizontal axis.

Will this work for a line chart?
Usually, yes. Select the category axis along the bottom and set Vertical axis crosses to At maximum category. The precise controls can vary if the chart uses a date axis or has unusual category-order settings.

How do I move only the Y-axis numbers to the right?
Select the vertical axis and adjust Format Axis > Labels > Label Position. That moves the labels, not the axis line. The available positions depend on the chart type and Excel version.

Does the method work for a scatter chart?
Yes, but use the maximum value on the numeric horizontal axis rather than At maximum category. In a scatter chart, both axes are value axes.

Can I put the Y-axis on the right in Excel for the web?
It may be possible if the chart-formatting pane exposes the crossing option. If you cannot find it or the setting is not available, use the desktop Excel app to change the axis crossing point.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.