Create an interval plot with overlaid groups

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

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

To create an interval plot 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 > Interval 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 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 > Interval Plot.
  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