How to Create a Zip Code Heat Map in Excel (with Useful Steps)

Get FREE Advanced Excel Exercises with Solutions!

If you are looking for how to create a Zip code heat map in Excel, then you are in the right place. In statistical analysis or any other research work, we need to prepare map with data in such a way that we can represent that effectively. A Heat map is one of the most effective ways to represent statistical data. In this article, we’ll try to discuss how to create a Zip code heat map in Excel.


What Is a Heat Map?

Heat map (or heatmap) is a data visualization approach which uses color to depict a phenomenon’s size in two dimensions. The reader will receive clear visual clues about how the occurrence is clustered or fluctuates over space from the fluctuation in color, which may be by hue or intensity. The cluster heat map and the spatial heat map are two fundamentally distinct types of heat maps. In a cluster heat map, magnitudes are arranged into a matrix of fixed cell size, where the rows and columns represent discrete phenomena and categories.
The position of a magnitude on a spatial heat map, in contrast, is determined by its location in that space; there is no concept of cells, and the phenomena can change continuously.


How to Create a Zip Code Heat Map in Excel: with Easy Steps

Excel offers some easy steps to create a Zip code heat map effectively. We just need to follow those steps to prepare a heat map.


1. Creating a Dataset and Table

Firstly, we need to make a dataset which includes Zip codes of different locations. Here, we have made the following dataset named Dataset of Zip Codes which has column headers as City, State, Abbreviation, and Zip Code.

how to create a zip code heat map in excel

  • Secondly, we need to create a table.
  • For this, firstly, select the cells of B4:E20 > go to Home > select Format as Table > choose any table option. In this case, we have selected the Light Blue table option.

Creating a Dataset and Table

  • Eventually, a Create Table window will appear.
  • Thirdly, make sure that the range of cells is the selected cells and My table has headers option is selected > click OK.

how to create a zip code heat map in excel

  • Eventually, the table with the drop-down options in the column headers will be like this.


2. Working with Insert Option

After creating the table, we need to add a map based on the table.
To do this, firstly, select the table > go to Insert > click Maps > select Filled Map.

Working with Insert Option

  • Consequently, a map will appear according to the table.

how to create a zip code heat map in excel

  • Secondly, change the Chart Title to Zip Code Heat Map.
  • Additionally, we’ll see that the color change according to higher to lower Zip codes is represented on the right side.


3. Dealing with Chart Design

After adding the map, we need to design the chart map.
If we want to change the color of the chart, firstly, select the chart > go to Chart Design > select Change Colors > select any options from the color options.

Dealing with Chart Design

Consequently, the color of the chart will change like this.

how to create a zip code heat map in excel

Now, to add Data Labels, right-click on the chart > select Add Data Labels.

how to create a zip code heat map in excel

Consequently, the chart with the Data Labels will be like this.

Additionally, we can also format the Data Labels to represent the chart more effectively.

  • In order to format it, firstly, right click any of the data inside the chart > choose Format Data Labels.

  • Eventually, a Format Data Labels window will appear.
  • Secondly, select the Category Name and Value boxes in the Label Options.

how to create a zip code heat map in excel

  • Finally, the Zip code heat map with proper Data Labels will be like this. Where the light color zones have a smaller Zip code and the larger the Zip code the deeper the color.

how to create a zip code heat map in excel

Read More: How to Make Geographic Heat Map in Excel


Download Practice Workbook


Conclusion

That’s all about today’s session. And these are the ways to create a Zip code in Excel. We strongly believe this article would be highly beneficial for you. Don’t forget to share your thoughts and queries in the comments section. We will be at your aid as soon as possible.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Shajratul Alam Towhid
Shajratul Alam Towhid

Hello, myself Shajratul Alam Towhid. Basically, I am a Naval Architect who wants to expand knowledge in the field of Microsoft Excel. I wish all of my articles will be beneficial for the readers.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo