Create a separate scatterplot for each group

You can create graphs like the following examples using data arranged in different layouts in the worksheet.

Scatterplot of Gender = F
Scatterplot of Gender = M

These scatterplots show the height vs weight of female college students and the height vs weight of male college students.

To create a separate scatterplot for each group, choose the layout option that is similar to your worksheet.

Option 1

Follow these steps if your worksheet contains at least one pair of columns of X-Y data and at least one column of categorical data for grouping.

Example worksheet

C1 C2 C3-T
Height Weight Gender
66.0 140 M
61.0 140 F
72.0 160 M
... ... ...
  1. Choose Graph > Scatterplot.
  2. Choose Simple, then click OK.
  3. Under Y variables, enter a column of y-values. In the example, Weight is the Y variable.
  4. Under X variables, enter a column of x-values. In the example, Height is the X variable.
  5. Click Multiple Graphs, then click the By Variables tab.
  6. In By variables with groups in separate graphs, enter the categorical grouping variable. In the example, Gender is the categorical grouping variable.
  7. Click OK in each dialog box.

Option 2

Follow these steps if your worksheet contains multiple pairs of columns of X-Y data, and each X-Y column pair is a group.

Example worksheet

C1 C2 C3 C4
Height Male Height Female Weight Male Weight Female
66.0 61.0 140 140
72.0 65.0 160 135
74.0 61.5 190 108
... ... ... ...
  1. Choose Graph > Scatterplot.
  2. Choose Simple, then click OK.
  3. Under Y variables, enter a column of y-values. In the example, Weight Male is the Y variable.
  4. Under X variables, enter a column of x-values. In the example, Height Male is the X variable.
  5. Repeat steps 3 and 4 for each additional pair of X-Y variables. In the example, Weight Female is the second Y variable and Height Female is the second X variable.
  6. Click OK.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy