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 
  
  

The idea of how to create Choropleth Maps with Microsoft Excel is the brainchild of Tushar Mehta, Microsoft Excel MVP. Robert Mundigl has also written a series of comprehensive, advanced Excel articles on Choropleth charts and is distributing a set of free templates, attached below. I would like to thank Robert Mundigl and Andy Pope for their comments.

---

choropleth_map_templates.zip
File Size:	797 kb
File Type:	zip

Download File

---