X
X
The Best Tech Newsletter Anywhere

Join 250,000 subscribers and get a daily digest of news, geek trivia, and our feature articles.

How to Switch Chart Axes in Google Sheets

Google Sheets

When you’re creating graphs or charts in Google Sheets, you don’t need to stick with the default layout. Google Sheets will try to pick your X- and Y-axes automatically, which you might wish to change or switch around.

To do this, you’ll need to open your Google Sheets spreadsheet and select your chart or graph. With your chart selected, click the three-dot menu icon in the top-right corner and then select “Edit The Chart” from the drop-down menu.

On a selected Google Sheets chart, press the three-dots menu icon, then press the "edit the chart" option

Alternatively, right-click your chart and select the “Data Range” option from the pop-up menu.

On a Google Sheets chart, right-click and press "Data Range" to begin editing the chart axes.

Both options will bring up the “Chart Editor” panel on the right-hand side, where you can alter the style and data settings for your chart.

RELATED: How to Make a Graph in Google Sheets

Under the “Setup” tab, you’ll see the columns currently used for the X- and Y-axes under the “X-Axis” and “Series” options. The first column listed under the “Series” is used for the Y-axis.

The axes used for a Google Sheets chart will be listed under the "X-axis" and "Series" columns in the "Setup" tab of the "Chart Editor" panel.

If you want to switch these around, you can do so manually by swapping the labels in the “X-axis” and “Series” options.

For example, a chart below shows the product sales of computer devices, with prices and sales dates shown. The prices are currently used for the X-axis, while the sales dates are used for the Y-axis.

An example Google Sheets chart with the X and Y axes shown in the Chart Editor panel.

To change this data, click on the current column listed as the “X-axis” in the “Chart Editor” panel. This will bring up the list of available columns in your data set in a drop-down menu.

Select the current Y-axis label to replace your existing X-axis label from this menu. In this example, “Date Sold” would replace “Price” here.

Click on an X or Y axis label in the Google Sheets Chart Editor panel, then select an alternative column from the drop-down menu.

If the data is correct, this will leave you with a chart that has the same data shown as the X and Y-axes. You’ll need to repeat these steps for the first column listed under the “Series” category to replace the Y-axis next.

In this instance, replacing “Date Solid” (the current Y-axis and new X-axis label) under “Series” with the “Price” column (the original X-axis label) from the drop-down menu.

To change the Y-axis on a Google Sheets chart, select the first column listed under the "Series" category in the "Setup" tab of the Chart Editor panel and select a replacement column.

If the columns provide correct data to form your chart’s X- and Y-axes, your chart will update to show the axes have been switched.

For this chart example, the “Price” column is now listed in the vertical Y-axis on the left, while the “Date Sold” column (with sales dates) are shown on the horizontal X-axis on the bottom.

An example Google Sheets chart with X and Y axes switched.

If the columns you’ve chosen are incorrect, you can remove them from your chart entirely by clicking the three-dots menu icon next to a column listed under the “X-Axis” or “Series” categories, then clicking “Remove” from the drop-down menu.

To remove a label from a chart in Google Sheets, click the three-dots menu icon next to a column listed under the "X-Axis" or "Series" categories, then press the "Remove" option.

Once you’ve deleted a column from your X or Y-axes, you’ll need to re-add it by clicking the “Add X-Axis” or “Add Series” box, then selecting a new column from the drop-down menu.

Click "Add X-Axis" or "Add Series" to add an X or Y-axis to a Google Sheets chart or graph in the Chart Editor panel.

This will then update your chart to show the new X or Y-axis using the data you selected.

Ben Stockton Ben Stockton
Ben Stockton is a freelance tech writer from the United Kingdom. In a past life, he was a UK college lecturer, training teens and adults. Since leaving the classroom, he's been a tech writer, writing how-to articles and tutorials for MakeUseOf, MakeTechEasier, and Cloudwards.net. He has a degree in History and a postgraduate qualification in Computing.
Read Full Bio »

The above article may contain affiliate links, which help support How-To Geek.
How-To Geek is where you turn when you want experts to explain technology. Since we launched in 2006, our articles have been read more than 1 billion times. Want to know more?

x

The Best Tech Newsletter Anywhere

Join 250,000 subscribers and get a daily digest of news, comics, trivia, reviews, and more.