Create a bar chart with groups on separate panels

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 on separate panels, choose the layout option that is similar 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 Simple, 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 variable, enter a column of categorical data. In the example, Temperature is the categorical variables for grouping.
  7. Click Multiple Graphs, then click the By Variables tab.
  8. Under By variables with groups in separate panels, enter one or more columns of categorical data. In the example, GlassType is the categorical variable for paneling.
  9. Click OK in each dialog.

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 Simple, 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 date/time data. In the example, 1, 2, and 3 are the graph variables.
  6. Click Multiple Graphs.
  7. Under By variables with groups in separate panels, enter one or more columns of categorical data. In the example, Temperature is the categorical variable for paneling.
  8. Click OK in each dialog.

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 Simple, then click OK.
  4. Under Graph variables, enter the column of summarize data. In the example, Mean LightOutput is the graph variable.
  5. Under Categorical variable, enter a column of categorical data. In the example, Temperature is the categorical variable.
  6. Click Multiple Graphs, then click the By Variables tab.
  7. Under By variables with groups in separate panels, enter one or more columns of categorical data. In the example, GlassType is the categorical variable for paneling.
  8. Click OK in each dialog.

Option 4

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 Simple, then click OK.
  4. In the example, Temperature is the categorical variableUnder Categorical variables, enter a column of categorical data. In the example, Temperature is the categorical variable.
  5. Click Multiple Graphs, then click the By Variables tab. In the example, Temperature is the categorical variable.
  6. Under By variables with groups in separate panels, enter one or more columns of categorical data. In the example, GlassType is the categorical variable for paneling.
  7. Click OK in each dialog.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy