According to Wikipedia, a choropleth map (Greek χωρα + πληθαίν:, ("area/region" + "multiply") is a thematic map in which areas are shaded or patterned in proportion to the measurement of the statistical variable being displayed on the map, such as population density or per-capita income. The choropleth map provides an easy way to visualize how a measurement varies across a geographic area or it shows the level of variability within a region.
My main contribution to choropleth map Excel dashboards is a simple VBA trick, which assigns functional OnAction macros and screen-tips (through the hyperlink route) to every country shape in the map. This tip can be used with any shape object.
- Map Shapes Explained
- ScreenTips and OnAction Macro for Choropleth Maps
- European Choropleth Map Demo
- Visible Text behind Shapes
- How to Group Shapes