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
Next, highlight the cell range D1:H17, then click the Insert tab along the top ribbon, then click Chart.
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:
The following tutorials explain how to perform other common tasks in Google Sheets: