PRODUCT

U.S. – State Heat Map – Excel Template

PURPOSE

This Excel template makes it easy to create geographic heat map at the state level for 50 states of U.S.

U.S. Geographic Heat Map - Excel Template - Map
U.S. Geographic Heat Map – Excel Template – Map

 

REQUIREMENTS

You need a copy of Microsoft Excel. Supported versions: Microsoft Excel for Windows (2007, 2010, 2013, 2016), Microsoft Excel for Mac (2011, 2016)

PRODUCT TOUR VIDEO

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

HIGHLIGHTS

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

 

HOW TO USE:

  1. Enter Tile and Note as needed.

    U.S. Geographic Heat Map - Excel Template - Input
    U.S. Geographic Heat Map – Excel Template – Input
  2. Copy and paste the data from other sources into the template. Or you can type the data directly.

    U.S. Geographic Heat Map - Excel Template - Data
    U.S. Geographic Heat Map – Excel Template – Data
  3. Choose whether you would like to see data labels appear on the map

    U.S. Geographic Heat Map - Excel Template - Data Labels
    U.S. Geographic Heat Map – Excel Template – Data Labels
  4. By default, the map shows gradient color scale with dark red being the lowest value and the dark green being the highest value. If you don’t prefer the gradient scale, you can change that by choosing YES to the ‘Use Data Ranges?’ question.  You can have up to 6 groups/buckets and you can choose a color for each group. There are seven colors to choose from. In the example ranges, states with value from 0 to 1001 will be in RED whereas states with >=10001 will be in BLUE.

    U.S. Geographic Heat Map - Excel Template - Data Ranges
    U.S. Geographic Heat Map – Excel Template – Data Ranges
  5. View/Print/Export the Heat map. Or you can copy the image and paste in other applications as needed.

 

U.S. Geographic State Heat Map - Excel Template - With Data Labels
U.S. Geographic State Heat Map – Excel Template – With Data Labels

PRINTING
In Excel, when you try to print, the print area in the file is already pre-set to print only the map.

If you would like to print the entire sheet, click ‘Ignore print area’ when you print (as shown in the image below). That would print the entire sheet.

U.S. Geographic Heat Map - Excel Template - Print sheet
U.S. Geographic Heat Map – Excel Template – Print sheet

SAVING AS PDF
Similarly, you can save as PDF. By default, only the map will be saved in the PDF.
SaveAsPDF

 

If you would like the entire sheet to be saved in PDF, choose Options and check the ‘Ignore Print Area’ option.

SaveAsPDF_IgnorePrintArea

COPY/PASTE

You can also copy the image by right clicking on the map and choosing ‘Copy’. You can then paste in other applications such as PowerPoint and Word.

 

 

BUY

US$15

CUSTOMER RATING

100% SATISFACTION

If you are not satisfied with the product, please e-mail support@indzara.com and we will issue a full refund.

FILE DELIVERY PROCESS

You will be able to download the file immediately upon payment. You will also receive an e-mail immediately with the download link.

FREE UPGRADES

All future updates and upgrades are absolutely free.

LICENSE TERMS

PRODUCT SUPPORT

PRODUCT SUPPORT

OFFER

Offer Details

Special Offer - Buy One, Write Review, Get One Free

ADD A REVIEW

1 2 3 4 5

US$15