Create a dotplot with stacked groups on separate panels

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

This dotplot compares the savings and debt of a sample of people in their 20s and in their 30s.

To create a dotplot with stacked groups on separate panels, 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 two columns of categorical data for grouping.

Example worksheet

C1 C2-T C3-T
Data Type Age
5000 Savings 20s
1200 Debt 20s
15000 Savings 30s
... ... ...
  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, Data is the graph variable.
  4. In Categorical variables for grouping, enter two to four columns of categorical data. In the example, Type and Age are the categorical variables 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, plus at least one column of categorical data for grouping.

Example worksheet

C1 C2 C3-T
Savings Debt Age
5000 1200 20s
15000 1000 30s
3900 2000 20s
... ... ...
  1. Choose Graph > Dotplot.
  2. Under Multiple Y's, choose Stack Groups, then click OK.
  3. Under Graph variables, enter two or more columns of numeric or date/time data. In the example, Savings and Debt are the graph variables.
  4. In Categorical variables for grouping, enter up to four columns of categorical data. In the example, Age is the categorical variable for grouping.
  5. Click OK.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy