Create a boxplot with groups on separate panels

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, and paneled by the machine that produced them.

To create a boxplot with 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 C3
Data Week Machine
5.19 1 1
5.57 2 2
8.73 3 1
... ... ...
  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 Multiple Graphs, then click the By Variables tab.
  6. In By variables with groups in separate panels, enter a column of categorical data. In the example, Machine is the categorical panel variable.
  7. Click OK in each dialog box.

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 C4
Week1 Week 2 Week 3 Machine
5.19 5.57 8.73 1
5.53 5.11 5.01 2
4.78 5.76 7.59 1
.. ... ... ...
  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 Multiple Graphs.
  5. In By variables with groups in separate panels, enter a column of categorical data. In the example, Machine is the categorical panel variable.
  6. 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