How to Make Axes Continuous Google Sheets

In this tutorial, I am going to guide you on how to add axis titles in Google Sheets.

Charts and graphs are helpful to display and analyze data. Different types of charts in Google Sheets can be used to understand the nature (trend) of the dataset that we have.

With a couple of clicks, Google Sheets allows you to create your very own chart featuring the data in your datasheet.

You can either use Google Sheets on your desktop computer or you can use the app on your mobile phone.

The Google Sheets app is the mobile version of Google Sheets available for Android and Apple iPhones.

Once you get your chart, you may need to make some modifications to its visuals/graphics for better representation.

Axis titles are one of the things you can do to improve the readability of your charts. Adding or changing axis titles is simple and in this tutorial, I am going to explain to you how it is done:

How to Add Axis Titles in Google Sheets

Axis Titles in Google Sheets can be added using the Chart Editor. To add axis titles in Google Sheets do the following:

1. Enter data values in Google Sheets
2. Select the data by highlighting it
3. Click on insert chart
4. Click on the three dots on the upper right-hand side of the chart
5. Click on "Edit chart"
6. In the Chart Editor click on "Customize"
7. Then open up "Chart& axis titles"
8. Change between "Horizontal axis title" and "Vertical axis title"
9. Enter the axis titles in "Title text"
10. The axis titles are now visible in your chart

How to Add Axis Titles in Google Sheets

How to Create A Chart in Google Sheets

As I mentioned earlier, you need to have some sort of dataset in your Google Sheet to create a chart from it.

For the sake of this article, let's say, I have the following data in my Google Sheet:

Data Values in Google Sheets

As you can see in this screenshot, I am using simple data with two columns that are for the x-axis and y-axis respectively.

And now, I want to create a very basic simple column chart using this data where the values in the column named x-values will be the data values for the x-axis and the values in the column named y-values will be the data values for the y-axis.

There are two ways of creating a Column Chart from this dataset.

Method 1 – Insert The Chart first And Then Select Data for the Chart in Google Sheets

In this method, first, we will insert a chart into our Google Sheet and then edit the chart and select the data for it. Following are the needed steps:

Step 1 – Insert a Chart into the Google Sheet

Go to the insert tab of your Google Sheet and click on chart:

Create a Chart in Google Sheets

A simple chart will be inserted with no data:

Chart with no Data in Google Sheets

Step 2 – Select Data for the Inserted Chart in Google Sheets

Now, as we have added a chart to our Google Sheet, we need to select data for our chart.

For this, I'm going to copy my previous data into this current sheet and select it for my inserted chart.

Here are the steps to select the desired data for the chart:

1. Open the Chart Editor pan

This pan can be opened by:

a.) Double-clicking on the chart

b.) Click on the menu button on the top-right of the chart and click "edit chart":

Edit Chart in Google Sheets using the Chart Editor

2. Select the data range for the chart

In the heading "Data range" click in the box below to type the range of your dataset (e.g., in my case, data range is A1:B11) OR click on the small boxes (on the right side) to see and select from the suggested data ranges.

Selecting or typing in a data range in the chart editor

Select or type in the desired data range and click OK.

3. The values will be represented in the chart area

Data values are displayed in the chart area

This is the basic procedure of selecting the data range for the inserted empty chart.

We can further customize the data range selected, to see the results as per our requirements.

Google Sheets automatically adds x & y values as a series for the column chart and no values for the x-axis.

Method 2 – Insert a Chart While Keeping the Active Cell in the Dataset

Using the second method, Google Sheets will automatically sense the data range and display the data values on the inserted chart.

You will have to keep the active cell in your data set range or its neighborhood column or row.

Step 1 – Click anywhere in the dataset

Step 2 – Insert the chart

Go to the insert tab of your Google Sheet and click on chart:

Insert a chart in Google Sheets

Step 3 – A Chart will be inserted

A chart will be inserted automatically showing the data values. Google Sheets automatically inserts the line chart.

The data values are converted to a chart automatically in Google Sheets

Adding Chart Axis Titles

After the successful insertion of our chart in Google Sheets, it's time to add/edit the chart axis titles.

Now, here in my case, as you can see in the chart inserted using Method 1, there are no chart axis titles at all, while in the chart inserted using Method 2, the axis titles are automatically added.

So, I am going to use Method 1 to teach you how to add the chart axis and also edit them. Here are the steps:

Step 1 – Open Chart Editor Pan

This pan can be opened by:

a.) Double-clicking on the chart
b.) Click on the menu button on the top-right of the chart and click "edit chart":

Open the Chart & Axis Title Section in the Chart Editor

Step 2 – Open Chart & Axis Titles Section

Click on the Customize tab in the Chart editor pan
Click on (open) the Chart & axis titles section

Customize Chart & axis titles

Step 3 – Edit Horizontal Axis Title

Click on the Dropdown named Chart title and select the option "Horizontal Axis Title"

Choose the horizontal axis title in the Chart Editor in Google Sheets

The options to customize the horizontal axis (x-axis) title will appear.

Enter the Title text in the Chart editor

Type the Horizontal axis title of your choice (I'm going to type "X-Values"). It will appear on the chart.

The x-axis title is now visible in the chart

Same procedure for the vertical axis (y-axis) title (I'm going to type "Y-Values").

The y-axis can title can be added in the same way to your Google Sheets Chart

Conclusion On How to Add Axis Titles in Google Sheets

So, I hope this guide helps you in adding chart axis titles in Google Sheets.

For editing the axis titles, you can also directly access the Axis editing section by double-clicking the axis name already present there.

carsonbect1941.blogspot.com

Source: https://trustedtutorials.com/how-to-add-axis-titles-in-google-sheets/

Share this post