Making an x and y axis graph on Google Sheets is a piece of cake. There are plenty of different types of charts that use x and y axis and you simply need to select the data you wish to make into a graph and then navigate to **Insert > Chart**Â and select the chart type youâ€™d like. For example, you could use a scatter graph or a histogram.

Table of Contents

## What Are Y-Axis and X-Axis on a Graph?

In a 2D graph, the x and y axes are two lines at a 90-degree angle intersecting at an origin point 0 for both quantities. The axes are used to represent two different variables through a graphical representation. The horizontal lineÂ on a graph generally represents theÂ x-axis and is located on the bottom. The vertical lineÂ represents theÂ y-axis and appears towards theÂ middle or left side of theÂ graph.

For example, if you want to create a graph representing temperature and time, the x-axis will represent the time values and the y-axis will be used to represent the temperature. By plotting a xy graph, you can visually show the relationship between the two variables.

## Types of X and Y on a Graph

The x and y axis display different types of information in different graphs. Let’s take a look at some of the commonly used graphs that employ the x and y-axis.

**Bar Chart:**A bar chart is a popular way to repreÂsent data using rectangular bars. The heÂight or length of each bar corresponds to theÂ values being preseÂnted in the table. Typically, oneÂ axis is used to define diffeÂrent groups of data, while the otheÂr measures the valueÂs for those groups.**Line Graph:**A line graphÂ uses straight lines to connect different points on the graph. In this type of graph, the x-axis usually represents the independent variable, such as time. In contrast, the y-axis shows the dependent variable, such as sales, population, or temperature.**Histograms:**Histograms are a typeÂ of graph that displays the distribution of continuous data in an easily understandable manner. They reÂsemble bar graphs but incorporate information on freÂquency and categories. TheÂ x-axis is used to represeÂnt the range of values, whileÂ the y-axis showcases the freÂquency of each category’s valueÂs.**Scatter Plot:**A scatter plot can show the relationship between any two given variables. The x and y axes can represent a variable, and a dot can plot points on a graph.

## How to Graph X and Y Axis on Google Sheets

To create a graph in Google Sheets, you need to have the data in tabular form in your spreadsheet.

- Open the spreadsheet where you want to create the graph or chart for the x and y-axis.

- Here, click and drag across the table to select it. This will be represented with a blue tint across the cells.

- Click
**Insert**in the main toolbar, then click the**Chart**button in the dropdown menu. This will add a chart and open the chart editor menu towards the right side of the screen.

- In the
**Chart editor**, click on the option under**Chart type**Â and select the type of chart you want to create.

- Ensure the
**Data range**contains the cell range for the data you want to add to the chart.

- To customize the chart, click on the
**Customize**Â button in the**Chart editor**. There you can select the options that allow you to make visual changes to the chart.

For a more in-depth guide on making charts in Sheets, check out our article on everything you need to know about Google Sheets charts.

## How to Graph Equations on Sheets

A lot of times, you may have an equation in the cell. When plotting a graph for cells with formulas, Google Sheets will treat it the same way as it would for cells containing raw numerical values. This means the process should be the same if the formula’s output is numerical.

For this example, we have a dataset where the values for **X-axis **are between **1-10**, and **Y-axis**Â uses the formula **=2*(N^3) **where **N **is the corresponding value from **X.**

Here is how to create a chart for this:

- Click on the initial cell and drag the fill handle to select the dataset.

- Now, click on
**Insert**in the main bar and then click on**Chart**. This will add the chart and open the chart editor.

- Like the steps in the previous heading, click on the option under
**Chart type**Â in the**Setup**Â section and select the type of chart you want to create.

- To customize the chart, click on
**Customize**in the header bar.

This article focused on creating charts with two data ranges. If you want multiple data ranges in your Sheets chart, check out the linked article.

## How to Switch the Y and X-Axis

Sheets usually take a good guess at the chart type you want to use and smartly create the chart. However, it’s sometimes inaccurate, so you may want to swap the data on the X and Y axis. Here is how to swap X and Y axis on Sheets:

- Click on the graph to select it, and click on the ellipsis icon at the top right of the chart. This will open a dropdown menu.

- Click on the
**Edit Chart**Â button here. This will open the**Chart editor**window towards the right side of the screen.

- Make sure youâ€™re in the
**Setup**tab. You can select this using the button towards the top. - Here, you will see labels for
**X-axis**and Series. Click on the option under X-axis and change it to the other parameter. In this case, we are changing it to**Y**. - Repeat this step and change the Series option to the parameter for X-axis.

Switching the axis can be very beneficial when Google Sheets fails to intelligently detect the axis for the graphs. Here is an in-depth guide to switching X and Y axis in Sheets.

## Frequently Asked Questions

### Where Is the X-Axis on a Graph?

The X-axis is the horizontal axis on a graph and is usually located towards the bottom if the graph consists of positive numerical values. The X-axis represents the independent variable and typically goes left to right on the graph.

### Where Is the Y-Axis in a Graph?

The Y-axis is a vertical axis on the graph and is located towards the left side. It represeÂnts the dependeÂnt variable or what changes due to adjustmeÂnts in the independeÂnt variable. Generally, it eÂxtends from the bottom to the top of theÂ graph.

### How Can I Graph X and Y Axis on Google Sheets?

To create a graph for the x and y axes on Sheets, enter your data into the spreadsheet and select the data. Now, click on **Insert**Â the main bar and click on **Chart,**Â which will add the chart. Here, select the **Chart type**Â and the **Data range**.

## Wrapping Up

That should be everything you need to know about making an x and y axis graph in Google Sheets. If you have any questions, please let us know in the comments. If you found this guide useful and would like to support the Spreadsheetpoint team, consider purchasing one of our premium templates. You can even use the code SSP to save 50% on any downloads.

Get Premium Templates**Related:**

- How to Make a Bar Graph in Google Sheets
- Save Chart as Image in Google Sheets
- How to Make a Line Graph in Google Sheets
- How to Make a Histogram in Google Sheets
- How to Make a Scatter Plot In Google Sheets
- How to Create a Pie Chart in Google Sheets
- Gantt Chart in Google Sheets
- Everything You Need to Know About Google Sheets Charts
- How to Make a Google Sheets Combo Chart