Create a dotplot with stacked groups

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

This dotplot compares the calcium intake of children who attended an education program to the calcium intake of children who did not attend the program.

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

Option 1

Follow these steps if your worksheet contains a column of measurement data and at least one column of categorical data for grouping.

Example worksheet

C1 C2-T
Calcium Group
646.72 Control
1120.67 Education
1067.25 Control
... ...
  1. Choose Graph > Dotplot.
  2. Under One Y, choose Stack Groups, then click OK.
  3. Under Graph variables, enter a column of numeric or date/time data. In the example, Calcium is the graph variable.
  4. In Categorical variables for grouping (1-4), enter up to four columns of categorical data. In the example, Group is the categorical variable for grouping.
  5. Click OK.

Option 2

Follow these steps if your worksheet contains multiple columns of measurement data and each column is a group.

Example worksheet

C1 C2
Control Education
646.72 1120.67
1067.25 1212.86
1099.65 1005.38
... ...
  1. Choose Graph > Dotplot.
  2. Under Multiple Y's, choose Stack Y's, then click OK.
  3. Under Graph variables, enter two or more columns of numeric or date/time data. In the example, Control and Education are the graph variables.
  4. Click OK.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy