Create a bar chart with groups in clusters

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

This bar chart compares the light output of an oscilloscope at different combinations of glass type and temperature.

To create a bar chart with groups in clusters, 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. Minitab graphs a function of the data, such as the mean or the sum.

Example worksheet

C1 C2 C3
LightOutput GlassType Temperature
550 1 100
1070 1 125
1328 2 150
... ... ...
  1. Choose Graph > Bar Chart.
  2. Under Bars represent, choose A function of a variable.
  3. Under One Y, choose Cluster, then click OK.
  4. Under Function, choose the function of the graph variable that you want to graph. In the example, Mean is the function.
  5. Under Graph variables, enter a column of numeric or date/time data. In the example, LightOutput is the graph variable.
  6. Under Categorical variables for grouping, enter two or more columns of categorical data. In the example, Temperature and GlassType are the categorical variables for grouping.
  7. 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. Minitab graphs a function of the data, such as the mean or the sum.

Example worksheet

C1 C2 C3 C4
1 2 3 Temperature
550 1035 1328 100
1070 1312 1000 100
530 579 1299 150
... ... ... ...
  1. Choose Graph > Bar Chart.
  2. Under Bars represent, choose A function of a variable.
  3. Under Multiple Y's, choose Cluster, then click OK.
  4. Under Function, choose the function of the graph variable that you want to graph. In the example, Mean is the function.
  5. Under Graph variables, enter multiple columns of numeric or date/time data. In the example, 1, 2, and 3 are the graph variables.
  6. Under Categorical variables for grouping, enter one or more columns of categorical data. In the example, Temperature is the categorical variable for grouping.
  7. Under Scale Level for Graph Variables, choose the order for the graph variables on the X-scale. In this example, choose Graph variables displayed innermost on scale.
  8. Click OK.

Option 3

Follow these steps if your worksheet contains a column of summarized data and two or more corresponding columns of categorical data.

Example worksheet

C1 C2 C3
Mean LightOutput GlassType Temperature
1000 1 100
980 2 100
950 3 100
... ... ...
  1. Choose Graph > Bar Chart.
  2. Under Bars represent, choose Values from a table.
  3. Under One column of values, choose Cluster, then click OK.
  4. Under Graph variables, enter the column of summary data. In the example, Mean LightOutput is the graph variable.
  5. Under Categorical variables for grouping, enter two or more columns of categorical data. In the example, Temperature and GlassType are the categorical variables for grouping.
  6. Click OK.

Option 4

Follow these steps if your worksheet contains multiple columns of summarized data and a corresponding column of row labels.

Example worksheet

C1 C2 C3 C4
1 2 3 Temperature
550 1035 1328 100
1070 1312 1000 125
530 579 1299 150
  1. Choose Graph > Bar Chart.
  2. Under Bars represent, choose Values from a table.
  3. Under Two-way table, choose Cluster, then click OK.
  4. Under Graph variables, enter multiple columns of summary data. In the example, 1, 2, and 3 are the graph variables.
  5. Under Row labels, enter the corresponding column of categories (row labels). In the example, Temperature contains the row labels.
  6. Under Table Arrangement, choose the order for the groups on the X-scale. In this example, choose Rows are outermost categories and columns are innermost.
  7. Click OK.

Option 5

Follow these steps if your worksheet contains multiple columns of categorical data and each row is an observation. Minitab graphs the counts for each unique combination of categories.

Example worksheet

C1 C2
GlassType Temperature
1 100
1 125
2 150
... ...
  1. Choose Graph > Bar Chart.
  2. Under Bars represent, choose Counts of unique values.
  3. Choose Cluster, then click OK.
  4. Under Categorical variables, enter two or more columns of categorical data. In the example, Temperature and GlassType are the categorical variables.
  5. Click OK.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy