Create a bar chart of summarized data in a single column: clustered

Complete the following steps to create a bar chart that displays the summarized data for groups that are defined by values in a categorical variable, clustered by the values of a different categorical variable. If your data are arranged differently, go to Choose a bar chart.

  1. Open the dialog box.
    • Mac: Choose Graphs > Bar Chart > Summarized values for each category in a table > Single Column of Values: Clustered.
    • PC: Choose GRAPHS > Bar Chart > Summarized Data > Single Column of Values: Clustered.
  2. In Summary variable, enter the column of summary data that you want to graph.
  3. In Categorical variables, enter two columns of categorical data that define the groups. The variable that you enter first becomes the outermost variable on the axis. For more information, go to Interpret the key results for Bar Chart and click Step 2: Compare groups within groups.

In the following worksheet, Count is the summary variable and contains the number of customers who prefer a type of chocolate. Preference and Gender are the categorical variables and indicate the type of chocolate and gender that correspond to each count. For example, row 1 indicates that 87 men prefer dark chocolate. The graph shows the counts for men and women, clustered by preference. Preference is the outermost variable on the axis.

C1 C2 C3
Count Preference Gender
87 Dark M
102 Milk M
22 White M
90 Dark F
135 Milk F
17 White F
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy