Follow these steps to create a bar chart that displays summarized values for groups in separate columns, when there is also a grouping variable. If your data are arranged differently, go to Choose a bar chart.
In the following worksheet, 1st shift, 2nd shift, and 3rd shift are the summary variables. These columns contain the counts of rejected products for each work shift. Machine ID is the column of row labels and indicates which machine manufactured the rejected products. The graph shows the counts of rejected product for each machine, clustered by the shift.
|Machine ID||1st shift||2nd shift||3rd shift|