Create a histogram with overlaid groups

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

This histogram shows the distribution of torque values needed to remove caps on shampoo bottles, grouped by the machine that fastened the caps.

To create a histogram 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
Torque Machine
24 1
14 2
18 1
... ...
  1. Choose Graph > Histogram.
  2. Choose With Groups, then click OK.
  3. Under Graph variables, enter a column of numeric or date/time data. In the example, Torque is the graph variable.
  4. In Categorical variables for grouping (0-3), enter up to three columns of categorical grouping variables. In the example, Machine 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
Machine 1 Machine 2
24 14
18 27
17 32
... ...
  1. Choose Graph > Histogram.
  2. Choose With Groups, then click OK.
  3. Under Graph variables, enter two or more columns of numeric or date/time data. In the example, Machine 1 and Machine 2 are the graph variables.
  4. Select Graph variables form groups.
  5. Click OK.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy