How to make a scatter chart in Google Sheets – Best Guide in 2023

A scatterplot, also referred to as a scatterplot, is a helpful tool for data analysts to visually explore and analyze two different sets of data. Here’s how to create a scatter chart in Google Sheets. For instance, a scatter chart will show you which sales department performs better (or worse) when comparing the sales results of various sales departments, as opposed to a line chart.

The free Google Sheets program can be used to create a scatterplot in place of using Excel, which is one option. In this article, we’ll show you how to make a scatterplot in Google Sheets and how to edit it after it’s been made.

How to make a scatter chart
How to make a scatter chart

Google Sheets scatter chart creation instructions

As the name implies, a scatterplot makes two or more types of related data appear as scattered points on a chart. An ideal scatterplot would show profit versus sales revenue and show profit and revenue for each salesperson, for instance, if you wanted to compare the sales and profit of a sales team. It is possible to create a scatterplot if you have two comparable datasets, and Google Sheets makes it simple with a charting tool. Open your spreadsheet in Google Sheets and choose the data-containing cells to create a scatterplot. After selecting your data, choose Insert > Chart from the menu.

Fantastic Chrome Extensions You Must Install

With this, the right pane will open and display the Chart Editor tool. With the selected data, Google Sheets will attempt to automatically determine what kind of chart or graph to use. If the Google Sheets scatter chart is not already chosen, choose it from the Chart Type drop-down list found under the Customize tab. Hovering over a chart’s title will reveal its name if you are unsure of what it represents.
The range of data for the graphical chart will be created by the chart editor using the selected cells. Click the Select Data Range button (located next to the Data Range box) to change this. or manually enter a set of cells in the Data Range box.
The inserted chart will switch over instantly to the new type. A scatterplot has an X-Axis by default that connects two types of data (such as the names of a sales department). You can compare two (or more) different types of data in a row, such as profit and revenue. Choose one of the extra datasets from the list and click the Add series box to add another series.
Select the hamburger menu icon and then pick the Delete option to remove a particular episode from the series.

Check the Use Row 1 as Headers checkbox to force Google Sheets to use the top row for header names. Checking the Use Column A as Labels checkbox will allow you to use the first column as headings as well. The Switch Rows/Columns button allows you to alternate between rows and columns.

Setup for a scatter plot

Similar to how Google Sheets’ other charts and graphics can be customized by adding additional formatting, altering their colors, etc. Changes can be made to labels, axis titles, fonts, etc.

Verify that the chart editor panel on the right side is accessible before making any changes to the scatterplot. If not, choose the chart and then choose the hamburger menu icon in the top right corner. The Edit Chart option can be chosen from the menu.

You can begin altering your chart in the Customize Chart Editor tab of the menu. Changes to the chart’s colors and fonts can be made by choosing the Chart Style category and one of the options (for instance, background color). Your modifications will be automatically reflected.

You can modify the titles that are displayed for the chart and its axes under Chart and Axis Titles. After choosing a title from the Chart Title drop-down menu, paste the desired text into the Title Text box. The options below the field let you format the text (including its font, formatting, and color).

In Google Sheets, scatterplot data points are shown as circles by default. Select the Category Series, then select a new shape from the Point Shape drop-down menu to use instead (such as triangles or X marks). The Point Size drop-down menu also lets you choose a different point size.

You can tell which dataset the points on the scatterplot belong to using the legend. Select Category Legend and make your changes there by choosing from the available options to alter the font, formatting, color, and position of the legend.
You can modify the formatting of the various axis labels in the Horizontal Axis and Vertical Axis categories. Change the font, font size, formatting, and color by choosing from the available options after choosing any category. Select the Reverse axis order check box to change the axes’ direction from left to right or right to left.

Gridlines and ticks can be added to the scatterplot to improve visibility. Choose the category Gridlines and Elevations, then choose either the Horizontal Axis or the Vertical Axis from the drop-down menu. Selecting the Basic Ticks check box will enable tick marks on the horizontal axis once you have the Horizontal Axis option selected. From there, you can adjust the settings (such as position, length, color, and thickness) below the check box.
You can enable gridlines (both major and minor) and elevations for the vertical axis by selecting the Vertical Axis option in Gridlines and Elevations. Make adjustments to the settings (including Color, Position, Length, Thickness, and Color) below it after selecting Major Gridlines, Minor Gridlines, Major Ticks, or Minor Ticks and checking the boxes to enable those options.
making tables that can be seen.You can try your hand at making other Google Sheets graphs and charts to analyze data, such as line charts and bar charts, now that you know how to create a scatterplot in the program. Google Sheets Templates are available to help you get started if you’re having trouble so you can add data and make your own charts using it.Even though some features, like Excel Macros, are not supported, seasoned Excel users can easily convert spreadsheets to Google Sheets. By extending the functionality and integrating spreadsheets with other Google services and third parties using Google Sheets Script, you can go even further.

Leave a Comment