Indzara
(1 customer review)

Australia – State Heat Map – Excel Template

$10

Australia State Heat Map Excel Template

Description

A simple Excel template using which you can create instant heat maps for Australia using state-level data: Australia Heat Map Excel Template.

Australia Heat Map Excel Template - Australia Map
Australia Heat Map Excel Template – Australia Map

Features of Australia Heat Map Excel Template

  • Instant heat maps in Excel for 6 states and 2 territories of Australia.
  • Easy to print or save as PDF.
  • Copy the Heat map and paste it into other applications such as PowerPoint and Word.
  • Accepts state full names as well as standard abbreviations.
  • Option of gradient scale heat map or custom data ranges.
  • Customize Title and Notes that appear on the map.
  • State name and data values appear on map.
  • Control the presence of data labels on the map.

How to create the Australia Heat Map

Australia Heat Map Excel Template - Entering heat map data
Australia Heat Map Excel Template – Entering heat map data

 

  1. Enter Title that you would like to appear on the map.
  2. Enter the data
    1. Enter name of state/territory in the NAME/ABR column. You can also use the abbreviations instead of full name. Allowed names and abbreviations are provided at the bottom of the template.
    2. Enter data in the DATA column.
    3. Enter data label that you would like to appear on the map for each state/territory. DATA LABEL’ can be different from the ‘DATA’. This is helpful in cases where you would want to display some text/number that is different from the actual data. The data will be used for coloring while the data label will appear on the map.
  3. Enter NOTES that will appear at the bottom left of the map. You can use this to write commentary about the data used for the map.
  4. If you would like to show data labels on the map, choose ‘Yes’.
  5. The template by default provides gradient red (low) to green (high) color scale. You can change that and use a custom 6 color option. In order to do so, choose YES for USE DATA RANGES?
    1. Colors cannot be changed here but the ranges can be edited
  6. The map should automatically update after any changes to data. If the map doesn’t update, please press F9 to refresh.
Australia Heat Map Excel Template - Settings for Data labels and colors
Australia Heat Map Excel Template – Settings for Data labels and colors

 

Australia Heat Map Excel Template Demo

 

Printing

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

Australia Heat Map Excel Template - Print Screen
Australia Heat Map Excel Template – Print Screen

 

Saving as PDF

You can save as PDF and then e-mail it. By default, only the map will be saved in the PDF.

Australia Heat Map Excel Template - Export Screen
Australia Heat Map Excel Template – Export Screen

 

Australia Heat Map Excel Template - PDF options
Australia Heat Map Excel Template – PDF options

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

 

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.

 

Australia_HeatMap_ExcelTemplate_CopyImage
Australia – Geographic State Heat Map – Excel Template

CHANGING GRADIENT COLORS

If you would like to change the gradient colors used, please follow the steps outlined below.

1. Open the Conditional formatting menu in the Home ribbon and choose ‘Manage Rules’.

Australia_Geo_State_HeatMap_ExcelTemplate_ConditionalFormatting_1
Australia – Geographic State Heat Map – Excel Template – Conditional Formatting

2. Choose Sheet: Map Build

Australia_Geo_State_HeatMap_ExcelTemplate_ConditionalFormatting_2
Australia – Geographic State Heat Map – Excel Template – Conditional Formatting

3. Click on the Graded Colour Scale rule and then click ‘Edit Rule’.

Australia_Geo_State_HeatMap_ExcelTemplate_ConditionalFormatting_3
Australia – Geographic State Heat Map – Excel Template – Conditional Formatting

4. Change the colours (for minimum, midpoint and maximum) as needed. Then, Click OK.

Australia_Geo_State_HeatMap_ExcelTemplate_ConditionalFormatting_4
Australia – Geographic State Heat Map – Excel Template – Conditional Formatting

5. Click OK in the next dialog box to apply the changes.

Australia_Geo_State_HeatMap_ExcelTemplate_ConditionalFormatting_10
Australia – Geographic State Heat Map – Excel Template – Conditional Formatting

 

CHANGING COLORS FOR DATA RANGES

To change the colors used in the custom data ranges , in the Conditional Formatting Rules Manager, click on the rule associated with the color you would like to change. In the screenshot, we are changing the Orange color.

Australia_Geo_State_HeatMap_ExcelTemplate_ConditionalFormatting_5
Australia – Geographic State Heat Map – Excel Template – Conditional Formatting

 

In the Edit Formatting Rule dialog box, click on ‘Format’.

 

Australia_Geo_State_HeatMap_ExcelTemplate_ConditionalFormatting_6
Australia – Geographic State Heat Map – Excel Template – Conditional Formatting

 

Select the ‘Fill’ tab and then select any background color. Then, click OK.

 

Australia_Geo_State_HeatMap_ExcelTemplate_ConditionalFormatting_7
Australia – Geographic State Heat Map – Excel Template – Conditional Formatting

 

Click OK in the next dialog box.

Australia_Geo_State_HeatMap_ExcelTemplate_ConditionalFormatting_8
Australia – Geographic State Heat Map – Excel Template – Conditional Formatting

 

Click OK in the next dialog box. This would apply the chosen color.

Australia_Geo_State_HeatMap_ExcelTemplate_ConditionalFormatting_9
Australia – Geographic State Heat Map – Excel Template – Conditional Formatting

FAQ

Product Support

Australia State Heat Map (Excel) – Step by Step User Guide

1 review for Australia – State Heat Map – Excel Template

5.0
Based on 1 review
5 star
100
100%
4 star
0%
3 star
0%
2 star
0%
1 star
0%
1-1 of 1 review
  1. This is a very useful tool and presents well in reports and presentations as needed. It has enough customization features that it is worth the investment.

    (0) (0)
    • Thanks for your positive feedback.

Add a review
Australia - State Heat Map - Excel Template Australia - State Heat Map - Excel Template
Rating*
0/5
* Rating is required
Your review
* Review is required
Name
* Name is required

Australia – State Heat Map – Excel Template

$10