https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679815/Asset_68ee09db-d364-464a-87c3-ee15fd1a31c7/MSADataMap96.png

US Metropolitan Data Map

by Garden City Consultants

A tool to visualize the Metropolitan Statistical Area (MSA) data in geographic color map

Description:

US Metropolitan Data Map Add-In is a tool to visualize the Metropolitan Statistical Area (MSA) data in heat-map. This chart is an interactive chart that the user can see the chart updating while the data is entering the table.

Statistician, economic analyst, student, journalist can use this add-in for MSA data analysis.

The data format: the first column is valid MSA address, the second column is data value.

The paid user can see a link for the valid MSA address.

Instruction:

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

  • Click Insert sample data button to insert sample data.

  • Paste own data in the same format as the sample data into the sheet to replace the existing sample data or create own table in the same sheet.

  • The chart is binding to the table. The user can see the chart updating while the 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 set a title for the chart by clicking in the title area and enter the name as preferred.

Mouse over the MSA block in the map, the tool-tip shows the MSA region name and value.[/#LI]

App capabilities

When this app is used, it
  • Can read and make changes to your document
  • Can send data over the Internet

At a glance

https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679815/Asset_c87b554a-cd63-4aac-9737-b61b72d92d63/MSADataMap.png
https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679815/Asset_a028c6b4-0c90-416d-8a82-8ca086d32fef/MSADataMap2.png