How to Add Axis Labels in Google Sheets (With Example)

Often you may want to add or modify axis labels on charts in Google Sheets.

Fortunately this is easy to do using the Chart editor panel.

The following step-by-step example shows how to use this panel to add axis labels to a chart in Google Sheets.

Step 1: Enter the Data

First, let’s enter some values for a dataset that shows the total sales by year at some company:

Step 2: Create the Chart

To create a chart to visualize the sales by year, highlight the values in the range A1:B11. Then click the Insert tab and then click Chart:

By default, Google Sheets will insert a line chart:

Notice that Year is used for the x-axis label and Sales is used for the y-axis label.

Step 3: Modify Axis Labels on Chart

To modify the axis labels, click the three vertical dots in the top right corner of the plot, then click Edit chart:

In the Chart editor panel that appears on the right side of the screen, use the following steps to modify the x-axis label:

  • Click the Customize tab.
  • Then click the Chart & axis titles dropdown.
  • Then choose Horizontal axis title.
  • Then type whatever you’d like in the Title text box.

For example, we could type “Period” for the title text:

Google Sheets modify x-axis label

The x-axis will automatically be modified on the chart:

Repeat this process to change the y-axis label, except choose Vertical axis title in the dropdown menu:

Google Sheets modify y-axis label

The y-axis label will automatically be modified on the chart:

The x-axis label is now Period and the y-axis label is now Total Sales.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Create a Box Plot in Google Sheets
How to Create a Bubble Chart in Google Sheets
How to Create a Pie Chart in Google Sheets
How to Create a Pareto Chart in Google Sheets

Featured Posts

Leave a Reply

Your email address will not be published. Required fields are marked *