A Microsoft VBA Application for Generating Heat Maps

A choropleth map is a form of thematic map used to portray the structural characteristics of some particular geographical distribution not apparent in data presented in tabular form. Preparation of a choropleth map starts with the assignment of map features to classes based on the value of a specific feature attribute followed by the association of classes of features with appropriate map colors or symbols. Oftentimes, map features are geographical regions with naturally or artificially defined boundaries, but choropleth maps can also be prepared by segmenting the area to be mapped into a regular grid of regions. Maps prepared with each grid shaded in an intuitive manner such as blue for grids with the lowest attribute values to red for the highest values can be termed “heat maps”. This technical note describes the HeatMap Microsoft Excel application which converts information contained in a worksheet into a heat map, and then converts the heat map into a file suitable for display using mapping systems such as Google Earth. An example illustrates how the application can be used to visualize the 17th century frontier between the Polish/Lithuanian Commonwealth and the Ottoman Empire.