(For example: ) After you get the shapes, copy or insert them into a blank Excel workbook. These shapes are generally provided in powerpoint templates. You can Google 'editable powerpoint USA map' or something similar. The shapes should be free-form and editable. A full USA map doesn't work for this task. The development of this tool consists of 4 main parts:įirst, we will need to find, create, or import separate shapes for each of the states in the USA. If you don't have enough time to make one for yourself, you can take a look at the Ready-To-Use Heat Map Generators in Excel on
After you get the idea, you can implement the same for other cities and countries or even situations where the shapes might not even be geographical. In this article we will go over every step to create your own Geographic Heat Map Generator in Excel for USA states.
