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

To create a bar chart with groups in clusters, choose the layout option that is similar to your worksheet.

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.

C1 | C2 | C3 |
---|---|---|

LightOutput | GlassType | Temperature |

550 | 1 | 100 |

1070 | 1 | 125 |

1328 | 2 | 150 |

... | ... | ... |

- Choose .
- Under Bars represent, choose A function of a variable.
- Under One Y, choose Cluster, then click OK.
- Under Function, choose the function of the graph variable that you want to graph. In the example, Mean is the function.
- Under Graph variables, enter a column of numeric or date/time data. In the example, LightOutput is the graph variable.
- 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.
- Click OK.

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.

C1 | C2 | C3 | C4 |
---|---|---|---|

1 | 2 | 3 | Temperature |

550 | 1035 | 1328 | 100 |

1070 | 1312 | 1000 | 100 |

530 | 579 | 1299 | 150 |

... | ... | ... | ... |

- Choose .
- Under Bars represent, choose A function of a variable.
- Under Multiple Y's, choose Cluster, then click OK.
- Under Function, choose the function of the graph variable that you want to graph. In the example, Mean is the function.
- Under Graph variables, enter multiple columns of numeric or date/time data. In the example, 1, 2, and 3 are the graph variables.
- Under Categorical variables for grouping, enter one or more columns of categorical data. In the example, Temperature is the categorical variable for grouping.
- 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.
- Click OK.

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

C1 | C2 | C3 |
---|---|---|

Mean LightOutput | GlassType | Temperature |

1000 | 1 | 100 |

980 | 2 | 100 |

950 | 3 | 100 |

... | ... | ... |

- Choose .
- Under Bars represent, choose Values from a table.
- Under One column of values, choose Cluster, then click OK.
- Under Graph variables, enter the column of summary data. In the example, Mean LightOutput is the graph variable.
- 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.
- Click OK.

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

C1 | C2 | C3 | C4 |
---|---|---|---|

1 | 2 | 3 | Temperature |

550 | 1035 | 1328 | 100 |

1070 | 1312 | 1000 | 125 |

530 | 579 | 1299 | 150 |

- Choose .
- Under Bars represent, choose Values from a table.
- Under Two-way table, choose Cluster, then click OK.
- Under Graph variables, enter multiple columns of summary data. In the example, 1, 2, and 3 are the graph variables.
- Under Row labels, enter the corresponding column of categories (row labels). In the example, Temperature contains the row labels.
- 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.
- Click OK.

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.

C1 | C2 |
---|---|

GlassType | Temperature |

1 | 100 |

1 | 125 |

2 | 150 |

... | ... |

- Choose .
- Under Bars represent, choose Counts of unique values.
- Choose Cluster, then click OK.
- Under Categorical variables, enter two or more columns of categorical data. In the example, Temperature and GlassType are the categorical variables.
- Click OK.