When you create a chart or chart in Google Sheets, you don’t need to use the default layout. Google Sheets will try to automatically select your X and Y axes, which you may want to change or switch.
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 Chart” from the drop-down menu.
Alternatively, right-click your chart and select the “Data Range” option from the pop-up menu.
Both options will display a “Chart Editor” pane on the right, where you can change the style and data settings for your chart.
Under the “Setup” tab, you will see columns currently used for the X and Y axes under the “X-Axis” and “Series” options. The first column listed under “Series” is used for the Y axis.
If you want to change it, you can do it manually by switching the labels in the “X axis” and “Series” options.
For example, the chart below shows sales of computer equipment products, with prices and sales dates displayed. Current price is used for the X axis, while sales dates are used for the Y axis.
To modify this data, click on the current column listed as “X axis” in the “Chart Editor” pane. This will bring up a list of the columns available in your data set in a drop-down menu.
Select the current Y-axis labels to replace your existing X-axis labels from this menu. In this example, “Sale Date” will replace “Price” here.
If the data is correct, it will leave you with a chart that has the same data displayed as the X and Y axes. You will have to repeat these steps for the first column listed under the “Series” category to replace the next Y axis.
In this example, replace “Solid Date” (current Y axis and new X axis label) under “Series” with the “Price” column (original X axis label) from the drop-down menu.
If the columns provide the correct data to form the X and Y axes of your chart, your chart will update to show that the axes have been replaced.
For this chart example, the “Price” column is now listed on the vertical Y-axis on the left, while the “Date Sold” column (with date of sale) is shown on the bottom horizontal X-axis.
If the column you selected is wrong, you can remove it from the chart completely by clicking on the three-dot menu icon next to the column listed under the “X-Axis” or “Series” category and then clicking “Delete” from the drop-down menu.
After you remove a column from the X or Y axis, you must add it back by clicking the “Add X axis” or “Add Series” box and select the new column from the Cannot drop-down menu.
This will then update your chart to display the new X or Y axis using the data you selected.