Create a scatterplot with overlaid groups

You can create a graph like the following example using data arranged in different layouts in the worksheet.

This scatterplot compares the height vs weight of male and female college students.

To create a scatterplot with overlaid groups, choose the layout option that is similar to your worksheet.

Option 1

Follow these steps if your worksheet contains 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 With Groups, 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. In Categorical variables for grouping (0-3), enter one or more columns of categorical grouping variables. In the example, Gender is the categorical variable for grouping.
  6. Click OK.

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 With Groups, 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. Check X-Y pairs form groups.
  7. Click OK.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy