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

[vc_row][vc_column][vc_column_text]

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

[/vc_column_text][vc_column_text]

Please visit the product page to understand the features of the U.S. Geographic State Heat Map Excel Template.

[/vc_column_text][vc_column_text]

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

 

[/vc_column_text][vc_column_text]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.[/vc_column_text][vc_column_text][/vc_column_text][/vc_column][/vc_row]

28 Comments

  • I want to have multiple tabs per Spreadsheet with different heatmaps. When I duplicate the tab, all subsequent tabs only calculate to the data and data label of the first tab. Is there a way to force each tab to have that map update to its own data table rather than the first tab of the spreadsheet?

    Reply
    • Duplicate tabs will not work since we have a hidden tab which takes the entered data to update in the map. If you want to duplicate the tabs, first you will have to duplicate the hidden tab, then duplicate the US_HEATMAP tab and modify the formulas & named rages in the duplicated hidden tab to collect input from the duplicated US_HEATMAP tab.

      I would like to inform you that we take customization project for additional fee. If you want us to duplicate the maps in same sheet, requesting to contact our support team at support@indzara.com for an estimation.

      Best wishes.

      Reply
      • Thank you for the response. It is good to know that the spreadsheet is updating to a hidden TAB. I have found a suitable work around for now.

        Reply
    • Thanks for purchasing.

      D.C. is currently not included in the template. 50 states are included. It appears that D.C. is a federal district. Also, the size of D.C. is small and it would not be very visible when plotted on the heat map, unless plotted in a different scale.

      Please let me know if there are any questions or suggestions.

      Reply
  • I am using percentages for my data. I want to add them to my data labels but they appear on the map as multi-decimal place numbers. How can I format the data labels so that it shows a percent.

    For instance, I am getting .515 instead of 51.5%

    Reply
    • Thanks for purchasing.
      To show percentages, please use the following steps.
      1. Change the format of DATA LABEL column to be %.
      2. Change the format of DATA LABEL column in hidden DATA sheet to be % (this feeds the boxes on the map). If we want decimal places, here is where we can edit the format.

      Thanks & Best wishes.

      Reply

Leave a Reply

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