Excel Instructions: Scatterplot
To do that in Excel:
- Right-click on one of the data points in your scatterplot and choose Select Data from the pop-up menu.
- Right now only one series is shown, and it is labeled weight. This series currently includes all of the data points for both male and female. We're going to change this series to represent only males, and add a new series to represent females. To do this:
- Click on the weight series to select it.
- In the box to the right under Name, type males.
- In the box under X values, change the formula so that the range includes only the data for males. In this case, you would change it to =Sheet1!$B$2:$B$58. Change the formula in the box under Y values in the same manner. Click OK.
- To add a new series click on the + button underneath the Legend entries (Series) box.
- Select the Series2 title, type females in the Name box.
- The easiest way to get the formulas right for the Series X values and Series Y values is to copy and paste the formulas from the male series. Do that and change the data range appropriately. In our case, for example, the formula for Series X values for the females series would be =Sheet1!$B$59:$B$82.
- Click the OK button when you're done.
You should now see two colors on the scatterplot, one for males and one for females, with the legend indicating which is which.