Description:

US Census Region Data Map Add-In is a tool to visualize US census division, census region, federal reserve bank (FRB) region data into geographic heat-map.

This add-in has three region types that can be selected in the Setting screen:

9 Census Divisions

4 Census Regions

12 Federal Reserver Bank Regions

Economic analysts, business analyst, student, journalists can use this add-in to visualize the census region data.

This add-in has three sets of sample data to allow the user to use it as template to build own data.

Instruction:

Download this add in and start Excel 2013 SP1 or later.

Select a region type in the drop-down.

Click Insert sample data button to insert sample data.

The users can paste own data in the same format into the sheet to replace the existing sample data or create their own table in the same [#LI]sheet. When building own data, please use the same region name as the ones in the sample data.

The map is binding to the table. When the user update the data in any cell and click enter. The map is refreshed as soon as the new data is entered.

If there are multiple tables in the sheet, the user can click the tool icon to go to the setting screen and click Bind to existing data button to select the table.

The user can rename the map title by clicking in the title area and reenter the name as preferred.

The color schema is customizable. In the setting screen, enter an RGB color values ( ex: #00FF00) in the Color Axis boxes.

When select a new region type, please clear the existing table data or select a different region before click insert sample data button.

US Region Data Map

by Garden City Consultants