Multi-Variable Grouped Percentage Bar Chart

This plotting tool creates a horizontal bar chart for multiple numeric variables and a category variable, where each bar shows each combination of variable and category as a percent of the total. Totals can be calculated for each variable or for each category.

This plot can be accessed from the Plot / Grouped percentage bar chart menu item.

The dialog for displaying a bar chart of percentages for multiple variables

To produce this plot, the following must be specified:

  • Whether all of the data should be used, or only the data values highlighted on the map and in the table.

  • One or more numeric variables, selected from the list on the left side of the dialog. Control-click and shift-click can be used to select multiple variables.

  • A single categorical variable for grouping the numeric data.

  • The method of aggregating values of each group for each variable. Alternatives are the arithmetic mean (the default), the geometric mean, the harmonic mean, the minimum, the maximum, the median, the count, and the sum.

After all this information has been specified, the aggregated data will be converted to percentages, by category, for each variable. The summarized data will be shown as a set of horizontal bars, one for each variable, with each bar divided and colored by category values.

The default arrangement of the mult-variable grouped percentage bar chart.

The Control-R keystroke will reverse the calculation of percentiles and the display, so that there is one bar for each category value, with each bar divided and colored by variable values.

The alternate arrangement of the mult-variable grouped percentage bar chart.

The Alt-T keystroke will prompt for a title and display it at the top of the plot.

The Alt-F keystroke will flip the order of values on the Y axis.

The “Source Data” button at the bottom of the dialog shows all of the selected data. The “Plot Data” button shows these data after aggregation and calculation of percentages by variable. These tables can be saved to a file with the Ctrl-S keystroke.