docs / articles / How to Create an XY Graph in Google Sheets

How to Create an XY Graph in Google Sheets

Sara Jul 09, 2026 2026-07-09 04:40:45

Creating an XY graph, also known as a scatter plot, in Google Sheets is a straightforward process that can help you visualize data relationships. Whether you're analyzing trends, comparing data sets, or simply want to present your data in an engaging way, understanding how to create an XY graph is a valuable skill.

How to create and customize charts in Google Sheets (Quick version)
How to create and customize charts in Google Sheets (Quick version)

Before we dive into the steps, ensure you have Google Sheets open and your data ready. For this example, let's assume you have two columns of data: one for X values (e.g., years) and one for Y values (e.g., sales).

the google spreadsheet dashboard is shown in this screenshot
the google spreadsheet dashboard is shown in this screenshot

Preparing Your Data

Before creating your graph, it's crucial to ensure your data is clean and well-organized. Remove any blank cells or errors, and ensure your data is in the correct columns.

Create and Graph in Google Sheets
Create and Graph in Google Sheets

For an XY graph, your data should be in two columns, with the X values in one column and the Y values in the other. You can name these columns to make your graph more understandable. For instance, you could name them "Years" and "Sales".

Selecting Your Data

How to Make Your Own Graphs Using PowerPoint - Lindsay Bowden
How to Make Your Own Graphs Using PowerPoint - Lindsay Bowden

Once your data is ready, select the range of cells containing your data. This includes both columns of data. To do this, click and drag your mouse over the cells, or click the first cell, then hold down Shift and click the last cell.

Alternatively, you can select the entire column by clicking the letter at the top of the column (e.g., A, B, C). This is useful if your data spans multiple rows but is in the same column.

Inserting the XY Graph

How to make a graph or chart in Google Sheets
How to make a graph or chart in Google Sheets

With your data selected, click on "Insert" in the menu, then hover over "Chart" in the dropdown. You'll see a variety of chart types. For an XY graph, select "Scatter" from the list of chart types that appear.

Google Sheets will automatically create a scatter plot using your selected data. The X values will be on the horizontal axis, and the Y values will be on the vertical axis.

Customizing Your XY Graph

How To Make a Pie Chart in Google Sheets (Step-by-Step)
How To Make a Pie Chart in Google Sheets (Step-by-Step)

Once your graph is created, you can customize it to better suit your needs. Click on the graph to select it, then click on the three vertical dots that appear in the top-right corner. This will open the "Chart editor" panel.

Here, you can change the title of your graph, add a title to the X and Y axes, and even change the color scheme. You can also add a trendline or change the marker style for your data points.

How To Create A Circle Chart In Google Sheets
How To Create A Circle Chart In Google Sheets
How to Make a Gauge Chart in Google Sheets
How to Make a Gauge Chart in Google Sheets
How to Create a Pie Chart in Google Sheets: A Simple Step-by-Step Guide (With Example)"
How to Create a Pie Chart in Google Sheets: A Simple Step-by-Step Guide (With Example)"
Make Graphs for Free Using GraphFree
Make Graphs for Free Using GraphFree
Google Graph Paper for Math - Teacher Tech with Alice Keeler
Google Graph Paper for Math - Teacher Tech with Alice Keeler
How to Make a Combo Chart in Google Sheets
How to Make a Combo Chart in Google Sheets
an image of a computer screen with many screens on it
an image of a computer screen with many screens on it
How to Make a Line Graph in Google Sheets | Itechguides
How to Make a Line Graph in Google Sheets | Itechguides
Google Classroom - Simple Spreadsheet and Pie Chart | K-5 Technology Lab
Google Classroom - Simple Spreadsheet and Pie Chart | K-5 Technology Lab
How to Use the MONTH Function in Google Sheets
How to Use the MONTH Function in Google Sheets
How to Calculate Average in Google Sheets
How to Calculate Average in Google Sheets
Printable Multiple Coordinate Graphs 6-per-Page
Printable Multiple Coordinate Graphs 6-per-Page
the google sheets has hidden gems you're not using on your webpages
the google sheets has hidden gems you're not using on your webpages
Struggling to add Alternating Colors in Google Sheets
Struggling to add Alternating Colors in Google Sheets
Google Sheets Charts / Graphs Tutorial
Google Sheets Charts / Graphs Tutorial
a screenshot of a spreadsheet with multiple columns and numbers on the screen
a screenshot of a spreadsheet with multiple columns and numbers on the screen
How to Make a Timeline Chart in Google Sheets
How to Make a Timeline Chart in Google Sheets
How to Show Formulas in Google Sheets
How to Show Formulas in Google Sheets
How to Make Graph Paper in Excel (+ video tutorial)
How to Make Graph Paper in Excel (+ video tutorial)
How to use Google Sheets: A beginner's guide | Zapier
How to use Google Sheets: A beginner's guide | Zapier

Changing the Title and Axes

In the "Chart editor" panel, click on "Customize" in the toolbar, then select "Chart & axis titles". Here, you can add a title to your graph and change the titles of the X and Y axes.

For example, you could name your graph "Sales Trends Over Time" and change the X axis title to "Years" and the Y axis title to "Sales (in $)".

Changing the Marker Style and Color Scheme

Still in the "Chart editor" panel, click on "Customize" in the toolbar, then select "Series". Here, you can change the marker style and color for your data points.

For instance, you could change the marker style to squares or triangles, and change the color to blue. You can also add data labels to your points if you want to highlight specific data points.

Updating Your XY Graph

One of the benefits of creating your graph in Google Sheets is that it updates automatically when you add or change data in your spreadsheet.

To update your graph manually, simply click on it to select it, then click the "Refresh" button in the "Chart editor" panel. This will update your graph to reflect any changes you've made to your data.

With your XY graph created and customized, you're ready to share your data insights with others. Whether you're presenting to colleagues, clients, or stakeholders, a well-designed XY graph can help you make your point clearly and effectively.