Table of Contents
To create a scatterplot with multiple series in Google Sheets, follow these steps:
1. Open Google Sheets and select the data you want to plot on the scatterplot.
2. Click on Insert in the menu bar and select Chart.
3. In the Chart Editor, choose Scatter from the chart types.
4. Under the Customize tab, click on Series.
5. Click on Add Series and select the data you want to add to the scatterplot.
6. Repeat this process for all the data series you want to include.
7. Customize the appearance of the scatterplot by adjusting the labels, axis, and other settings.
8. Click on Insert to add the scatterplot to your Google Sheet.
By following these steps, you can easily create a scatterplot with multiple series in Google Sheets. This will allow you to visually compare and analyze multiple sets of data on one chart, making it easier to identify patterns and trends.
Google Sheets: Create a Scatterplot with Multiple Series
Often you may want to create a scatterplot with multiple series in Google Sheets, similar to the plot below:
Fortunately this is easy to do in Google Sheets with some simple formulas.
The following step-by-step example shows exactly how to do so.
Step 1: Enter the Data
First, let’s enter the following dataset that contains information about assists and points for basketball players on various teams:
Step 2: Format the Data
Before we can create a scatterplot to visualize the assists and points for each team, we must first format the data in a specific manner.
First, we’ll enter the unique values for each group along the top row and then type the following formula into cell E2:
=IF($A2=E$1, $C2, NA())
Then drag this formula to the right until you hit cell H2.
Then drag it down to each cell until you hit cell H17:
Next copy all values from column B and paste them into column D:
Step 3: Create the Scatterplot
In the Chart editor panel that appears on the right side of the screen, choose Scatter chart as the Chart type:
The following scatterplot will appear:
Each point in the plot represents a unique player and the colors of the points correspond to the teams.
Feel free to add a title along with axis labels to make the plot easier to read:
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets: