U.S. Geographic State Heat Map – Excel Template – Support

Posted on
Welcome to the support page for the U.S. Geographic State Heat Map Excel template. You can create a geographic heat map at the state level for 50 states of U.S using your own data.

REQUIREMENTS

You need a copy of Microsoft Excel to open this file. The product has been tested in
  • Microsoft Excel 2007 and above (2010, 2013, 2016..)for Windows
  • Microsoft Excel 2011 and above (2016) for Mac

FEATURES

  • Instant Heat maps in Excel
  • Print or Save as PDF
  • Copy Heat map and paste it in other applications such as PowerPoint and Word
  • Accepts State full names as well as standard abbreviations
  • By default creates gradient scale heat map. You can also customize by selecting 6 different data ranges and choosing custom colors (from 7 different colors)
  • Displays data labels (that can be different from the data) on the map
  • Customize title and note as needed

 

Please see below for a list of support articles about this template.

  1. How to change Gradient Colors?
  2. How to change colors by data ranges?

If you have any questions about this Excel template, please leave a comment and I will respond as soon as I can. Thank you.

25 thoughts on “U.S. Geographic State Heat Map – Excel Template – Support

  1. How do you change the font type on the map itself?

    1. Please unhide a hidden sheet called Map. There you can edit the font size of the state labels and title. Please let me know if there are any questions. Thanks.

  2. The video shows that you can have different columns of information and then choose which column to display. I don’t see on the downloaded version how to add columns and then choose the data. Please tell me how to do this. Thanks.

    1. Thanks for purchasing. The version 1 of the template had that feature. In the second version published on Monday (Sep 21), only one column of data can be added. Instead, I have added other features such as adding data labels on map and changing colors on the map. If you need the v1 file, I can email it to you. Please email at indzara@gmail.com. Thank you.

  3. I am sorry that Puerto Rico is not added to this published template. Since the map shows only the official states, I kept the same 50 official states. Please email me at indzara@gmail.com if you need any assistance further. Thanks for your support.

  4. Hello,
    Is it possible to add Puerto Rico to this map?

    1. I will look into it for the next version. I plan to release the next version soon (likely September). Thanks.

  5. Hi I just downloaded the template and would like to change the map image that it uses is there a way to do that?
    I am a designer and would like to use a map from Adobe Illustrator which is better quality.
    Thanks

    1. Thanks for purchasing. I am sorry that the map cannot be changed that way. The map is basically created by drawing an outline of the states using lines and then colors are created using thousands of very small sized Excel cells.
      Are you trying to zoom into specific areas or taking a screenshot of the country as a whole? Please let me know where the quality is not as expected and I will look into it. You can email me at indzara@gmail.com. Thank you. Best wishes.

  6. I just purchased; how do I download the template?

    1. Thanks for purchasing. As soon as you purchase, you will receive an e-mail with a link to download the file. Also, if you have created an account with indzara.com while purchasing, you can log in and see all your purchased files.
      Please let me know if you have not received the email. Best wishes.

      1. Thank you. I hadn’t noticed that it was in the receipt.

        1. You are welcome. Best wishes.

  7. I just purchased, how do i download the template?

    1. Thanks. I forgot to mention here that I had emailed you my response to your question on the same day. Please let me know if there are any further questions. Thanks.

  8. I bought this excel template today. One question i have is how can i copy the template into another excel workbook.
    I tried the Home-Format-Copy Sheet option. But the copied workbook does not work as expected, that is when i change the data values the map does not reflect the changes. Please help!!

    1. Thanks for purchasing. If all the sheets, including hidden sheets, are moved to the new workbook, it should work. Please e-mail me the file at indzara@gmail.com if there are further questions. I will do my best to help.

      Thanks & Best wishes,

  9. Thanks for this excellent template. I changed the conditional formatting rule to drive three distinct colors: red, yellow and green. But some states have no value and I’d like them to display no color or white. Seems the default is red. How can I make this work? Thanks for your help.

    1. You could add a fourth rule. Choose ‘Format Only cells that contain’ rule and select Blanks in the drop down menu. Then, set the cell format to White.
      If this doesn’t help address your question, please e-mail me your file at indzara at gmail.com and I will look into it. Thanks for purchasing.

      Best wishes,

  10. I purchased the template but have not received the download and my card has been charged. I need someone to contact me ASAP.

    1. Just wanted to follow up on this. I had e-mailed you the file yesterday. I am sorry for the inconvenience.

      Thanks for purchasing.

Leave a Reply

Your email address will not be published. Required fields are marked *