U.S. State Heat Map (Excel) - Step by Step User Guide
Modified on: Tue, 5 May, 2020 at 6:26 AM
U.S. Geographic State Heat Map – Excel Template
Enter Tile and Note as needed.
Copy and paste the data from other sources into the template. Or you can type the data directly.
Choose whether you would like to see data labels appear on the map
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.
View/Print/Export the Heat map. Or you can copy the image and paste in other applications as needed.
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.
SAVING AS PDF Similarly, you can save as PDF. By default, only the map will be saved in the PDF.
If you would like the entire sheet to be saved in PDF, choose Options and check the ‘Ignore Print Area’ option.
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.