Create a histogram with groups on separate panels

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, paneled by the machine that fastened the caps.

To create a histogram 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 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 Simple, then click OK.
  3. Under Graph variables, enter a column of measurement data. In the example, Torque is the graph variable.
  4. Click Multiple Graphs, then click the By Variables tab.
  5. In By variables with groups in separate panels, enter the categorical grouping variable. In the example, Machine is the categorical variable for grouping.
  6. 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.

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 measurement data. In the example, Machine 1 and Machine 2 are the graph variables.
  4. Select Graph variables form groups.
  5. Click Multiple Graphs.
  6. Under Show Graph Variables, choose In separate panels of the same graph.
  7. 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