Google Sheets charts and graphs are a fantastic way to visualize data in your spreadsheet. While the default settings work well for quick visualizations, there are times when you need to make adjustments to achieve the desired look. One of the most common changes is adding or editing axis labels. In this article, we will explore how to add axis labels in Google Sheets and make your charts more informative.
Inserting a Chart or Graph in Google Sheets
To add axis labels to your chart, you first need to insert one in your spreadsheet. The process is straightforward:
Select the range of data you want to chart, including the headers.
Open the Insert menu and select the Chart option.
A new chart will be inserted, and you can customize it as needed in the Chart Editor sidebar.
Adding Axis Labels
Once you have your chart, it’s time to add axis labels to make it more informative:
Select the chart and click on the three-dot menu icon in the corner to open the Chart Editor. From the menu, choose Edit Chart.
Switch to the Customize tab by clicking on 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, you’ll find a dropdown menu to select the chart title you want to edit. Choose the vertical axis and type the label for the vertical axis into the Title Text field.
Repeat the process 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 in your graph, you may want to add an additional vertical axis label to the right side. Here’s how to do it:
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, you’ll find a dropdown menu to select the data series you want to edit. 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. Choose the label you want to edit and click on the dropdown menu. This time, you’ll see an additional 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.
In this tutorial, we have covered how to add and customize axis labels in Google Sheets. By following these steps, you can make your charts more informative and visually appealing. If you want to explore more Google Sheets tutorials, check out Mr Reviews for a wealth of helpful resources.