Create a scatterplot with groups on separate panels

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

This scatterplot shows the height vs weight of female college students and the height vs weight of male college students on separate panels.

To create a scatterplot with groups on separate panels, 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 panels, enter the categorical grouping variable. In this 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 Multiple Graphs.
  7. Under Show Pairs of Graph Variables, choose In separate panels of the same graph.
  8. Click OK in each dialog box.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy