You could also use Photoshop, Illustrator or other image editing software. If you insert an image of a map into Excel, you can use the image as an aid in tracing boundaries as you create the shapes. The shapes may be grouped together, so don't forget to 'Ungroup' the shapes after you get them into Excel.Īn alternative is to draw the shapes yourself in Excel using Insert > Shapes > Freeform: Shape. (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.

Download country heat for free