Counts of unique values: simple

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
...

Counts of unique values: clustered

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
... ...

Function of a single Y variable: simple

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
... ...

Function of a single Y variable: clustered

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
... ... ...

Function of multiple Y variables: simple

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
... ... ...

Function of multiple Y variables: clustered

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
... ... ... ...

Summarized data in a single column: simple

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

Summarized data in a single column: clustered

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

Summarized data in a two-way table: clustered

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
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy