Indzara
(1 customer review)

Canada – Heat Map – Excel Template

$10

Out of stock

Canada Heat Map Excel Template

Description

Canada Heat Map Excel template is an Excel template using which you can create instant heat maps for Canada using province/territory level data.

Canada Heat Map Excel Template
Canada Heat Map Excel Template

 

Features of Canada Heat Map Excel Template

  • Instant heat maps in Excel for 10 provinces and 3 territories of Canada.
  • Easy to print or save as PDF.
  • Copy the Heat map and paste it into other applications such as PowerPoint and Word.
  • Accepts province/territory 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.
  • Province/Territory name and data values appear on the map.
  • Control the presence of data labels on the map.

 

Data Entry - Canada Heat Map Excel Template
Data Entry – Canada Heat Map Excel Template
  • Enter Title that you would like to appear on the map.
  • Enter the data
    1. Enter name of Province/territory in the PROVINCE/TERRITORY column. The following names are allowed: ONTARIO, QUEBEC, ALBERTA, BRITISH COLUMBIA, MANITOBA, SASKATCHEWAN, NOVA SCOTIA, NEW BRUNSWICK, NEWFOUNDLAND AND LABRADOR, PRINCE EDWARD ISLAND, NORTHWEST TERRITORIES, YUKON, NUNAVUT. You can also use the abbreviations instead of full name: ON, QC, BC, AB, MB, SK, NS, NB, NL, PE, NT , YT, NU.
    2. Enter data in the DATA column.
    3. Enter data label that you would like to appear on the map for each province/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.
    4. 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.

      Settings - Canada Heat Map Excel Template
      Settings – Canada Heat Map Excel Template
  • If you would like to show data labels on the map, choose ‘Yes’.
  • 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. New colors cannot be added, but you can choose one of the six colors for each range

      Choose Color - Canada Heat Map Excel Template
      Choose Color – Canada Heat Map Excel Template
  • Press F9 to refresh the map with changes.
Canada Map Gradient Scale - Canada Heat Map Excel Template
Canada Map Gradient Scale – Canada Heat Map Excel Template

PRINTING

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

Print Canada Map - Canada Heat Map Excel Template
Print Canada Map – Canada Heat Map Excel Template

 

SAVING AS PDF

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

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

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.

Copy Image - Canada Heat Map Excel Template
Copy Image – Canada 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’.

Conditional Formatting Rules - Canada Heat Map Excel Template
Conditional Formatting Rules – Canada Heat Map Excel Template




2. Choose Sheet: MapBuild

Canada_HeatMap_Excel_Template_ConditionalFormatting_2

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

Conditional Formatting Rules - Canada Heat Map Excel Template
Conditional Formatting Rules – Canada Heat Map Excel Template

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

Changing Conditional Formatting Rules - Canada Heat Map Excel Template
Changing Conditional Formatting Rules – Canada Heat Map Excel Template

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

Gradient Color Scale - Changing Conditional Formatting Rules - Canada Heat Map Excel Template
Gradient Color Scale – Changing Conditional Formatting Rules – Canada Heat Map Excel Template

 

Product Tour Video

FAQ

Product Support

Canada Heat Map (Excel) – Step by Step User Guide

1 review for Canada – 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)
Add a review
Canada - Heat Map - Excel Template Canada - Heat Map - Excel Template
Rating*
0/5
* Rating is required
Your review
* Review is required
Name
* Name is required

Out of stock

Canada – Heat Map – Excel Template

$10