This article was last updated May 2018

A heat map highlights different levels of data (e.g. population size) per region on a map. To create a heat map, use eSpatial and follow the instructions below. Sign up for a free eSpatial trial here to start heat mapping your data!

heat map

Two Types of Heat Map

As you can see from the images above, eSpatial can create two types of heat map. Each type of heat map can give you different views of your data depending on the question you’re asking and the result you’re looking for.

Hot Spot Heat Map – This is a data styling option in eSpatial which takes data plotted on a map and reveals a density attribute (e.g., sales volumes per year, etc.) in a region that is not restricted to fixed geographic boundaries.

Regional Heat Map – This type of heat map summarizes and expresses data plotted within a defined region – state, country, etc. Levels of data present are distinguished by colors or shades (e.g., red = high volume, pink =- low volume).

Create a Hot Spot Heat Map

  1. Log in to your eSpatial account (get a free trial here). Upload your Excel spreadsheet data (or use the sample data in the Add Data panel, to see how it works)
  2. Click on the Style icon on the Control Panel to open the Style and Color Panel.

    Control Panel Styling 145
  3. On the Style & Color panel, which appears on the right side of the screen, make sure you have the correct dataset selected from the drop down menu on the top left of the Style and Color Panel and Select the Heatmap option.
Heat Map Styling Panel 145

Below, I’ve highlighted the heat map customization options. Experiment with these to create the best visualization for your data.

Heat Map Options Explained 145
  1. (Optional) Tick Overlay pins, at the bottom of the Style & Color panel, if you wish to see the original mapped uploaded data expressed as pins on top of the heat map. Tick Color Snapping if you wish to smooth out the edges of the heat map:
  1. Save your heat map and give it a title. It will be saved to your Library, then click Close. Save Button In Style Panel 145

Create a Regional Heat Map

You can quickly create a regional heat map using eSpatial (sign up here for a free trial).

Once you’ve uploaded your data or used our built-in sample data (available on the Add Data panel) you can create an Excel regional heat map (like the one above) by simply clicking on the Analyze Data button.

Analyze your data

Next, select Regional Heatmap:

Regional-heat-map

Now you need to select the data that you want to express on your heat map, as well as the region dataset.

Heat map dataset

Region datasets can be composed of pre-existing regions (e.g. US States, UK Counties, etc.) or on territory datasets you have previously created.

If you have no region datasets in your account, you can add the relevant region by clicking the Add Region Datasets button. In the panel (Add from Library), click the eSpatial datastore tab, find the dataset you want and then click Add to Map:

How to bubble map 2

Close this panel and you can see that the region dataset is now available from the Select region dataset drop-down menu.

(For more on datasets and the eSpatial datastore, go to our help pages).

Now simply click Complete to generate a heat map of your point data. If you use the sample data for your point dataset and the US States as your region dataset, as I have done, your Workspace should look like this:

Regional heat map with pins

You’ll notice that, by default, the map has retained the original pin data (the green markers). You can toggle these points on and off by clicking on the eye in the legend menu.

Hide legend dataset

If you are sharing the map and only want to show the heat map analysis (and not the point dataset), simply use the Save As button in the control panel, which is found when you click the Save icon.

Save your map

This allows you to save the Workspace heat map view as a unique map (you will still have the original – as long as you have saved it). And that’s how easy it is to create an Excel heat map using eSpatial. Take a look at the other types of maps you can create with eSpatial here

Are you a Salesforce User? Check out eSpatial for Salesforce on the AppExchange!

Paul Connolly
Written by

Paul Connolly

Paul Connolly is our Chief Product Officer, linking eSpatial’s product with evolving customer needs. Paul has been with eSpatial for the past 18 years during which time he has excelled in both software development and customer engagement roles. Paul holds a Masters in his discipline; Product Management. From here Paul has expertly led the product roadmap for eSpatial from a traditional server based install to include a highly successful SaaS offering we deliver today. Paul has been author on blog posts in a range of spaces through the years.

Ready to Get Started?

Create your first Excel heat map in minutes