PLUG IN FOR CLICK MAP INSTALL
PLUG IN FOR CLICK MAP CODE

Example 2: Populationįor this example, I downloaded the population for each country from the internet. Note: the geographic labels supported by the add-in are provided by clicking the Get Help button. Other settings include title, labels, and legend. We can also choose a Custom color theme and pick the desired colors: The default Red -> Green looks like this: We can then specify which column contains the geographic regions and which contains the values. Next, we use the Select button to choose the data source. In the Settings screen, we are able to choose a map, which includes options such as USA, World, Countries, and Continents. Note: you can also use the Insert Sample button to have the add-in create a table for you. Since our data is already in a table, we click Get Started and are presented with the Settings screen: We click Insert > My Add-Ins > Geographic Heat Map: In our illustration, we have the number of customers per state: For example, population density, per-capita income, number of stores, or number of reps.

Let’s say you have a table of data by geographic region. Note: depending on your version of Excel, you may or may not have access to these add-ins.

PLUG IN FOR CLICK MAP INSTALL

Install the Geographic Heat Map add-in and you’ll be ready to go. To get to the app store, just click Insert > Get Add-Ins. The Geographic Heat Map add-in is available in the app store. This type of display is called a choropleth map. By contrast, the Geographic Heat Map add-in can color the geographical regions themselves to encode the values. Note: we previously discussed the Bing Maps add-in which uses points that vary by size to encode aggregate values. Basically, it takes table data, such as the count of customers by state:Īnd then generates a corresponding display such as this: Objectiveīefore we examine the details, let’s understand what the add-in does. In summary, it enables us to easily visualize data on a map. In this post, we’ll take a look at the Geographic Heat Map add-in.

PLUG IN FOR CLICK MAP CODE

In addition to supporting zip code boundaries, Maptive also lets you draw a host of other geographical boundaries on your maps at the block, county, city, state, and even at the country level.This is the fourth post in the Add-Ins series, where we are exploring various add-ins that enhance and extend the capabilities of Excel. Zip code maps are also used by marketing, sales, and logistics teams to create powerful heat map data visualizations.įor example, if you use zip codes to map the sales territories of your salespeople, they’ll know the region they’re accountable for, and you can measure performance, study trends, and strategize through maps. With US demographics data, such as household income levels, you can fill in the gaps in your own data set to develop strategies for sales, marketing, real estate, and more. Maptive’s boundary tool allows you to create zip code boundaries populated with our complimentary data sets, such as US demographics and census data. No one has to be a data expert to understand what the data is telling (or showing) when using a map! Why Are Zip Code Maps Useful? Once you have created a map, share it with your team or export it and add it to your presentation.

Plug in for click map