Switch Chart Axes in Google Sheets - WindowsTips.net - Windows Tips and Tricks with Geek

Thursday, November 18, 2021

Switch Chart Axes in Google Sheets

 Google Sheets

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.

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.

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.

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.

No comments:

Post a Comment