How To Add Axis Labels In Google Sheets
Google Sheets charts and graphs are a handy way to visualize spreadsheet data.
It’s often possible to use the default settings for these charts without customizing them at all, which makes them a valuable tool for quick visualizations.
However, at times you’ll find you need to adjust the settings to get your chart looking the way you want.
One common change is to add or edit Axis labels. Read on to learn how to add axis labels in Google Sheets.
Insert a Chart or Graph in Google Sheets
If you don’t already have a chart in your spreadsheet, you’ll have to insert one in order to add axis labels to it.
Select the range you want to chart, including headers:
Open the Insert menu, and select the Chart option:
A new chart will be inserted and can be edited as needed in the Chart Editor sidebar.
Adding Axis Labels
Once you have a chart, it’s time to add axis labels:
Open the Chart Editor by selecting the chart and clicking on the 3 dot menu icon in the corner.
From the menu, select Edit Chart. The Chart Editor will open:
Switch to the Customize tab by clicking the word Customize at the top of the editor.
Click on the Chart & Axis Titles section to expand it:
At the top of the section is a dropdown menu to select which chart title you want to edit.
Choose the vertical axis from the menu and then type the label for the vertical axis into the Title Text field:
Repeat for the horizontal axis and, if desired, the chart title and subtitle
The new labels will immediately appear in your chart:
Adding Additional Vertical Axis Labels
If you have two data series, as shown in the graph above, you may want to add an additional vertical axis label to the right side of the graph. To do this:
Open the Chart Editor for the graph you want to edit and switch to the Customize tab
Click on the Series Section to expand it
At the top of the Series section is a dropdown menu to select which data series you want to edit. By default this will be set to Apply To All Series.
Choose the data series you want to display a label for on the right side of the chart:
Scroll down to the bottom of the series section and select Right Axis from the Axis dropdown menu
Go back to the Chart & Axis Titles section above the series section, and choose and click on the dropdown menu to select the label you want to edit.
This time, you’ll see an additional menu option for Right Vertical Axis Title. Click on it
Type the label you want to display on the right vertical axis into the box:
The new label will appear on the right side of your graph:
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to add axis labels in Google Sheets. Want more? Check out all the Google Sheets Tutorials.