Choose , then select a bar chart based on your data and how you want the graph to look.

- Counts of unique values: simple
- Counts of unique values: clustered
- Function of a single Y variable: simple
- Function of a single Y variable: clustered
- Function of multiple Y variables: simple
- Function of multiple Y variables: clustered
- Summarized data in a single column: simple
- Summarized data in a single column: clustered
- Summarized data in a two-way table: clustered

Create a bar chart that displays counts of unique values for one variable. The worksheet must include one column of categorical data.

The following worksheet contains a column of categorical data named Flaws. The graph shows the counts for each type of paint flaw.

C1 |
---|

Flaws |

Scratch |

Scratch |

Peel |

... |

Create a bar chart that displays counts of unique values for one categorical variable, clustered by the values of another categorical variable. The worksheet must include two columns of categorical data. Both columns must have the same number of rows.

The following worksheet contains two columns of categorical variables named Flaws and Shift. The graph shows the counts for each combination of paint flaw and shift.

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

Flaws | Shift |

Scratch | 1 |

Scratch | 2 |

Peel | 3 |

... | ... |

Create a bar chart that displays the mean or other function of values of a continuous variable, grouped by the values of a categorical variable. The worksheet must include a column of numeric data and a column of categorical data. Both columns must have the same number of rows.

The following worksheet contains a column of numeric data named LightOutput and a column of categorical data named Temperature. The graph shows the mean light output for each temperature level.

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

LightOutput | Temperature |

580 | 100 |

1090 | 125 |

1392 | 150 |

... | ... |

Create a bar chart that displays the mean or other function of values of a continuous variable, grouped by the values of a categorical variable, and clustered by the values of another categorical variable. The worksheet must include a column of numeric data and two columns of categorical data. All columns must have the same number of rows.

The following worksheet contains a column of numeric data named LightOutput, and two columns of categorical data named Temperature and GlassType. The graph shows the mean light output for each combination of glass type and temperature level.

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

LightOutput | Temperature | GlassType |

580 | 100 | 1 |

1090 | 125 | 1 |

1392 | 150 | 1 |

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

Create a bar chart that displays the mean or other function of several continuous variables. The worksheet must include multiple columns of numeric data.

The following worksheet contains columns of numeric data named Week 1, Week 2, and Week 3. The graph shows the mean for each week.

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

Week 1 | Week 2 | Week 3 |

5.19 | 5.57 | 8.73 |

5.53 | 5.11 | 5.01 |

4.78 | 5.76 | 7.59 |

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

Create a bar chart that displays the mean or other function of several continuous variables, clustered by the values of a categorical variable. The worksheet must include multiple columns of numeric data and one column of categorical data. The columns must have the same number of rows.

The following worksheet contains columns of numeric data named Week 1, Week 2, and Week 3, and a column of categorical data named Machine. The graph shows the mean for each machine, clustered by week.

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

Week 1 | Week 2 | Week 3 | Machine |

5.19 | 5.57 | 8.73 | 1 |

5.53 | 5.11 | 5.01 | 2 |

4.78 | 5.76 | 7.59 | 1 |

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

Create a bar chart that displays the summarized data for values of a categorical variable. The worksheet must include one column of summarized data and one column of categorical data. The columns must have the same number of rows.

The following worksheet contains a column of summarized data named Count and a column of categorical data named Preference. The graph shows the counts of each preference.

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

Count | Preference |

177 | Dark |

237 | Milk |

39 | White |

Create a bar chart that displays the summarized data for groups defined by a categorical variable, clustered by the values of a different categorical variable. The columns must have the same number of rows. The worksheet must include one column of summarized data and two columns of categorical data.

The following worksheet contains a column of summarized data named Count and two columns of categorical data named Preference and Gender. The graph shows the counts of preferences clustered by gender.

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

Count | Preference | Gender |

87 | Dark | M |

102 | Milk | M |

22 | White | M |

90 | Dark | F |

135 | Milk | F |

17 | White | F |

Create a bar chart that displays summarized values for groups in separate columns, when there is also a grouping variable. The worksheet must include multiple columns of summarized data and one column of row labels. The columns must have the same number of rows.

The following worksheet contains columns of summarized data named 1st shift, 2nd shift, and 3rd shift, and a column of row labels named Machine ID. The graph shows the counts for each machine, clustered by the shift.

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

Machine ID | 1st shift | 2nd shift | 3rd shift |

1 | 48 | 47 | 48 |

2 | 76 | 47 | 32 |

3 | 36 | 40 | 34 |