Heatmaps are popular in Excel because they can be used to show how different areas are heated up or cooled down. A heatmap can show you how many people live in a certain area, the type of housing that is available, the type of economy, the types of restaurants and bars that are available, and more.
Heatmaps can be very helpful in planning or forecasting events or trends. In this blog post, we’re going to learn how to create an excel geographic heat map add in.
GET STARTED WITH A GEOGRAPHIC HEAT MAP IN EXCEL
To make an excel geographic heat map add in, you’ll need the following:
- A spreadsheet with your data in it;
- A color scheme for your heat map;
- A blank heatmap template; and
- An Excel graph.
Start by making a new spreadsheet using the Data tab on the ribbon or select New from the File menu. In this example, we’re going to make an excel geographic heat map add in of all of North America.
Next, add your data to your spreadsheet. Keep in mind that you need specific fields for each location for the data to be analyzed properly. When adding these fields, remember to give them an X-axis and Y-axis label so that you can use them later when plotting on your map.
After adding your data, add a blank row above it and insert a chart into that row (Chart Wizard). Then make sure that you select Heat Map when prompted to choose what type of chart to create. Finally, select Blank Heat Map Template on the right side of the dialog box. You should now have two rows of data across the top and one row below it with an empty chart within it.
Next, go back up to your first row of data and fill out Column A with
CREATE YOUR HEATMAP USING THE DRAG AND DROP METHOD
The process of creating an excel geographic heat map add in is simple. You will use the drag and drop method to create your heatmap. This means that you’ll first need to open up your map in a new worksheet and then select a series of cells in the desired area. Next, you will copy all of the formulas in these cells and paste them into an adjacent cell so that they are all in one row. Next, click on all of the formulas and drag them down until the bottom of the page.
After your formulas reach the bottom, you will click on each one individually and drag them up until they reach the desired level for your map. Then, you will repeat this process for every other desired level on your map until it has reached its desired size.
CHANGE THE COLORS AND SHAPES OF YOUR HEATMAPS
To make a geographic heat map, all you need to do is add two columns and a row in your spreadsheet. The first column will be labeled “areas” and the second column will be labeled “heat areas.” The final column will be labeled “color.”
You want to divide your map into four sections, each representing one type of data you want to look at.
The first section will show the different types of housing available in the area represented by your heatmap. You’ll want to use red for condos, purple for single family homes, blue for small apartments, and green for large apartments or townhouses.
The second section will show the top 10 industries that are in the area represented by your heatmap. You can watch this video tutorial on how to create an industry list in Excel or just use this list as an example:
Healthcare, retail, finance/real estate/business services, education and training services, manufacturing/assembly operations (e.g., aerospace), construction and engineering services, transportation and warehousing services, government administration and defense
energy generation/production (e.g., nuclear power plant)
EXPORT YOUR HEATMAPS TO DIFFERENT FORMATS.
After you have created your excel geographic heat map add in, you can easily export it to a variety of file formats.
Excel offers three options for exporting your heatmap: the Heatmap Image option, the Excel Table option, and the PDF Exporter.
The Heatmap Image option is great if you want your heatmap to be interactive and show data in an image like a JPEG or PNG. The Excel Table option is useful if you want to use your heatmap as part of a pivot table or another analysis tool in Excel. Finally, the PDF Exporter can create very attractive and easy-to-read PDFs.
A geographical heat map in Excel is a good way to visualize the patterns of a particular geographical area, while also making quick changes so that you can see how your data changes over time.