Column chart symbols are used in maps to show the number of occurrences or proportions of categorical data associated to a single feature. Column chart symbols are created on a map using a string field and a location field containing coincident values.
Column chart symbols can answer questions about your data, such as the following:
- How are categorical values distributed geographically?
- How is the data ranked?
A GIS analyst working for a consortium of colleges wants to find which states have high-value colleges (for example, those with a high ratio of earnings after graduation compared to tuition and fee costs). Part of her analysis includes comparing the number or public, private for-profit, and private nonprofit schools both within and between states. Creating a map with column chart symbols allows the analyst to make both comparisons simultaneously.
The analyst can tell from the map that the states with larger populations have more colleges overall. She decides to normalize the data by changing the symbols from Expanded to Stacked Percent. That way, she can compare the proportions of college types between states without being influenced by the total numbers of colleges in the state.
Create a map with column chart symbols
Column chart symbols can only be created with multipart datasets in which features are collocated. These datasets can be created using a one-to-many join, or by enabling location on a dataset. If location is enabled with addresses or coordinates, Repeat identical features must remain unselected.
Use the following steps to create a map with column chart symbols:
- Expand a dataset in the data pane so that the fields are visible.
- Select the location field and the string field you want to visualize.
- Drag the fields to the page and drop them on the Map drop zone.
A unique values map will be created using Types (Unique Symbols) as the Symbol Type.
- Expand the legend to display the Layer options pane.
- Browse to the Options tab .
- Change Symbol type to Columns.
The Layer options pane is accessible from the layer legend and can be used to view the classification values being mapped, change the style of the map, and view information about selected features.
Use the Legend tab to view the values and counts of the column chart symbols and make selections based on the values. To change the color associated with a category, click the symbol and choose a color from the palette, or enter a hex value.
Use the Options tab to do the following:
- Change the field displayed on the map, or switch to a different type of map.
- Change the display between Stacked Count, Stacked Percent, and Expanded.
- Stacked Count—Each geographic feature is symbolized using a single bar with categories visualized as subgroups of the bar. The bar height is determined by the overall count for the geographic feature, and the height of each category segment is determined by the count of the category.
- Stacked Percent—Each geographic feature is symbolized using a single bar with categories visualized as subgroups of the bar. The bar height is uniform for each geographical feature, and the height of each category segment represents the percentage of that category relative to the geographic feature.
- Expanded—Each category is represented by a separate bar. Bar heights are determined by the count for each category.
Use the Style tab to change the symbol style properties, such as symbol size and layer transparency.
Use the Pop-up tab to view details for features selected on the map.
Column chart symbols show all unique categories associated with a single feature or location. If the features contain many unique categories or large differences between minimum and maximum counts, the column chart symbols may be difficult to interpret.