Create an individual value plot with multi-way grouping

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

This individual value plot shows the diameters of plastic pipes, measured over three weeks. The pipes were produced by two different machines.

To create an individual value plot with multi-way grouping, 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 > Individual Value Plot.
  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 two or more columns of categorical data. In the example, Week and Machine 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 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 > Individual Value Plot.
  2. Under Multiple Y's, choose With Groups, 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. In Categorical variables for grouping (1-3, outermost first), enter one or more columns of categorical data. In the example, Machine 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