Table of Contents
Creating a scatterplot with multiple series in Excel is a useful way to visually represent and analyze data that has more than one variable. To do so, follow these steps:
1. Select all the data points you want to include in the scatterplot.
2. Click on the “Insert” tab and select “Scatter” from the “Charts” section.
3. Choose the scatterplot style you prefer.
4. Right-click on the chart and select “Select Data” from the menu.
5. In the “Select Data Source” window, click on “Add” to add a new series.
6. In the “Edit Series” window, enter the series name and select the data range for the series.
7. Repeat steps 5 and 6 for each additional series you want to add.
8. Click “OK” to apply the changes and create a scatterplot with multiple series.
This feature allows for easy comparison and analysis of different data sets within one chart, making it a valuable tool for data analysis and presentation.
Create a Scatterplot with Multiple Series in Excel
Often you may want to create a scatterplot with multiple series in Excel, similar to the plot below:
Fortunately this is fairly easy to do in Excel 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 (X, Y) values for four different groups: A, B, C, and D.
Step 2: Format the Data
Before we can create a scatterplot to visualize the (X, Y) coordinates for each group, 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=H$1, $C2, NA())
We’ll then drag this formula to every cell to the right of cell E2. We’ll then drag it to every cell below H2 until we end up with the following result:
Step 3: Create the Scatterplot
Next, highlight every value in column B. Then, hold Ctrl and highlight every cell in the range E1:H17.
Along the top ribbon, click the Insert tab and then click Insert Scatter (X, Y) within the Charts group to produce the following scatterplot:
The (X, Y) coordinates for each group are shown, with each group possessing a unique color.
Feel free to modify the colors, point sizes, and labels to make the plot more aesthetically pleasing:
The following tutorials explain how to perform other common functions with scatterplots in Excel:
Cite this article
stats writer (2024). How can I create a scatterplot with multiple series in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-create-a-scatterplot-with-multiple-series-in-excel/
stats writer. "How can I create a scatterplot with multiple series in Excel?." PSYCHOLOGICAL SCALES, 6 May. 2024, https://scales.arabpsychology.com/stats/how-can-i-create-a-scatterplot-with-multiple-series-in-excel/.
stats writer. "How can I create a scatterplot with multiple series in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-create-a-scatterplot-with-multiple-series-in-excel/.
stats writer (2024) 'How can I create a scatterplot with multiple series in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-create-a-scatterplot-with-multiple-series-in-excel/.
[1] stats writer, "How can I create a scatterplot with multiple series in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, May, 2024.
stats writer. How can I create a scatterplot with multiple series in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.