An XY graph in Google Sheets, also known as a scatter plot, is a type of chart that displays data points on a cartesian coordinate system. With this type of graph, you can easily visualize and analyze the relationships between two sets of numerical data, represented by the horizontal (X) axis and the vertical (Y) axis values.
In this article, we will show you how to identify relationships in data sets by exploring the following methods to create an XY graph in Google Sheets. You’ll learn how to:
- Create an XY graph in Google Sheets, using its chart editor;
- Create an XY graph with your data in Google Sheets, Softr.
Create an XY graph in Google Sheets, using its chart editor
Cost: $0
Time: 3 minutes
Creating an XY graph in Google Sheets manually, rather than using tools, allows you to have full control over how your data is presented. To do so, follow the below steps:
Step 1: Select your dataset
Click and drag your mouse to select the range of data you want to use for your XY graph. You need to have two columns of data: one for the X-axis values; and another for the Y-axis values.

Step 2: Open the chart editor panel
Go to the "Insert" menu at the top of your Google Sheet and then select “Chart” to open the chart editor panel.

Step 3: Create a scatter chart
In the chart editor panel that appears on the right side of your screen, click on “Setup.” Under "Chart type," scroll down and select “Scatter."

Step 4: Customize your XY graph
Now that you have an XY graph in your spreadsheet in Google Sheets, you can customize various aspects of it, including the title, axis labels, and data series. To do so, click on “Customize” on the chart editor panel and follow the next steps.

Step 4.1: Customize the style
Under the “Customize” option, select “Chart style.”. In the unfolded menu, you can change the background color, the font, and the color of the chart’s border.
Once you are satisfied with your changes, click on “Reset layout” to save them.

Step 4.2: Customize the chart and axis title
Under the “Customize” option, select “Chart & axis titles.” In the unfolded menu, click on the first drop-down arrow to select which title you want to customize. You can choose from changing the chart’s title or subtitle, or even the horizontal or the vertical axis titles.
Once you’ve decided which title you want to change, you can field under “Title text” to type a new title. You can also change the title’s font, size, format, and color.

Step 4.3: Customize the series
Under the “Customize” option, select “Series.” There, you can change the appearance of any of the series that your XY graph is based on. In our example, we chose a series called “Exam points.”
In the Format section, you can then change the appearance of the points in the graph by changing their color, opacity, size, and shape. Making these changes will result in real-time changes in your XY graph.

Step 4.4: Customize the axis
Under the “Customize” option, select either “Horizontal axis” or “Vertical axis.” There, you can customize the axis label’s font, size, format, and color.
Additionally, you can check the “Reverse axis” checkbox to reverse the order of the information in the axis, so that the first data appears on the right or top of the XY graph. You can also use the “Slant labels” option to customize the appearance of data by slanting it to the desired angle.

Step 4.5: Customize the gridelines and ticks
Under the “Customize” option, scroll down and select “Gridlines and ticks. Then click on the drop-down arrow to select the axis you want to customize. In this example, we’ll select the vertical axis.
Next, customize the input fields named "Major spacing type," "Major step," "Minor spacing type," and "Minor count." Here’s what these terms mean:
- Major spacing type and Minor spacing type: The type of spacing used for the gridlines and tick marks on the vertical axis. They offer a choice between "Step" and "Count.”
- Major count and Minor count: The distance between the gridlines and tick marks on the axis. You can either choose “Auto,” “None,” or any number between 1 and 10.
In our example, we selected major and minor spacing as “Count” and choose 6 as the major count and 2 as the minor count.

Step 5: Save your XY graph
To save your XY graph, click on it, then click on the three dots that appear in the top right corner. Here, you’ll find several ways you can save your graph. Let’s explore each one in the following steps.

Step 5.1: Download your XY graph
In the drop-down menu that appears, select the “Download chart” option, then choose either PNG, PDF or SVG format to save your graph on your computer.

Step 5.2 Publish your XY graph
To publish your XY graph to the web, click on “Publish chart” in the drop-down menu that appears after clicking the three dots in the graph. You will then be asked if you’d like to publish your graph as a link or to embed it.

Step 5.3: Copy your XY graph
If you’d like to copy your XY graph into another document, click on “Copy chart” in the drop-down menu that appears after clicking the three dots in the graph. On the document where you want to save your graph, just use the right-click to paste it.

Step 5.4: Move your XY graph to its own sheet
In the drop-down menu that appears after clicking the three dots in your XY graph, you can click on “Move to own sheet.” This will result in your XY graph being moved to another sheet in the same Google Sheets file.

Create an XY graph with your data in Google Sheets, using Softr
You can also use Softr to create an XY graph. When you connect your Google Sheets account to Softr, you can create an XY graph whose colors, fonts, and other visual elements are customizable.
Step 1: Log in to Softr or create an account
First, you will need to log in to Softr. If you don’t have an account, you can sign up for Softr for free.

Step 2: Create a new Application
With your Softr account set up, it's time to create a new application where your graph will be housed.
On your Softr dashboard, locate and click on the "New Application" button.

Step 3: Select Blank application
Click on “Blank application” In the pop-up window that appears.

Step 4: Click on “Create application”
On the new page, click on “Create application".

Step 6: Add an XY graph
In the blocks sidebar, use the search bar to search a “scatter chart".

Step 7: Connect your data Source
In the new sidebar on the right side of your screen, click on “ Add another data source".

Step 8: Select your data storage
Next, you'll be prompted to choose a data source. Because you want your XY graph to use data stored in Google Sheets, select "Google Sheets" from the available options, and click on "Continue".

Step 9: Connect to Google Sheets
Now, you have to connect your Softr app with your Google Account. To do so, follow the next steps.
Step 9.1: Select a Google Account
A new window or tab will open asking you to login to or select your Google Account.

Step 9.2 Grant additional access
In this step, you’ll need to grant Softr access to a set of features. Click on "Select all" and then hit “Continue".

Step 10: Select your data
You can have multiple data sources in one Softr app, such as multiple Google Sheets files, so you need to select the particular Google Sheets file that has the data you want to use to create an XY graph.
Step 10.1: Select a data source
On the right side of the screen, Softr will show you all the block settings. In the tab "SOURCE," click on the "Source" dropdown and choose your data source. This will be the Google account where your data is stored.

Step 10.2: Select the Google Sheets file
Now, you will need to select the spreadsheet and the sheet where your data is by clicking on the "Document" and "Sheet" options.

Step 11: Customize your XY graph
Unlike Google Sheets, Softr offers many ways you can use to personalize your XY graph. Let’s check some examples.
Step 11.1: Change title and subtitle
In the FEATURES tab, you can change the title and subtitle of your XY graph.

Step 11.2: Customize the style
In the STYLES tab, you can customize the paddings to suit your preference.

Step 11.3: Customize Borders
Still, under the STYLES tab, you can also customize your graph’s background color and borders.

Step 14: Publish your graph
Once you’ve made all the changes to your graph, you can now save it by clicking on “Publish".

Step 15: You’ve created an XY graph using your Google Sheets data
Using Softr, you’ve created a customized XY graph using your data stored in Google Sheets. You can now choose to share this graph with whomever you desire and in accordance to the settings you defined in the previous step.

What is Softr
Join 700,000+ users worldwide, building client portals, internal tools, CRMs, dashboards, project management systems, inventory management apps, and more—all without code.