Create a boxplot with overlaid groups

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

This boxplot represents the diameters of plastic pipes measured over three weeks of production.

To create a boxplot with overlaid 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
Data Week
5.19 1
5.57 2
8.73 3
... ...
  1. Choose Graph > Boxplot.
  2. Under One Y, choose With 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 (1-4, outermost first), enter one or more columns of categorical data. In the example, Week 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 C3
Week 1 Week 2 Week 3
5.19 5.57 8.73
5.53 5.11 5.01
4.78 5.76 7.59
.. ... ...
  1. Choose Graph > Boxplot.
  2. Under Multiple Y's, choose Simple, then click OK.
  3. Under Graph variables, enter multiple columns of numeric or date/time data. In the example, Week 1, Week 2, and Week 3 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