Přeskočit na hlavní obsah

US County Data Map

Garden City Consultants

2.3 (3)

A visualization tool to turn the US county data into color heatmap

Description:

US County Data Map Add-In is a tool to visualize the US county data into color heat-map.

In the region drop-down, select the three supported regions in the map:

  • US Continental

  • Alaska Area

  • Hawaii Area

Using map region dropdown to switch region and click "Binding to Existing data" button when there is data in the sheet.

Features:

  • US county Data Map. Click herefor the county name.

  • Zoom in to view the detail county data.

  • The data format: name, State Code (2 characters).

  • Mouse over the map to view the data detail in the tool-tips.

  • Easy to use and user friendly are the key features of this add-in. Use sample data as the template to build your own data.

  • Interactive Chart: the chart is binding to the data table in the sheet, when you update the data, you can see the chart updating.

The map takes times to render, there is visible delay for each action. Please wait a moment for each action. Especially when checking/unchecking the Zoom In check box in the main map page.

Instruction:

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

  • Click Insert Sample Data image button on the top bar.

  • The users can paste their own data in the same format into the sheet to replace the existing sample data or create r own table in the same sheet.

  • The map is binding to the table. So as soon as the data is entered, the map is updated.

  • The user can update the data in any cell and click enter. The map is refreshed as soon as the new data is entered.

  • If the user has multiple tables in the sheet, the user can click the tool icon to go to the setting screen. And select the table, then click Bind to existing data button.

  • The user can rename the map title by clicking in the title area and reenter the name as preferred.
Schopnosti doplňku
Když se tento doplněk použije, může
  • Číst a měnit váš dokument
  • Posílat data přes internet
  • https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680894/Asset_a4fe0502-24a9-4d2c-a213-4d75caabf133/USCountyDataMap1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680894/Asset_a4fe0502-24a9-4d2c-a213-4d75caabf133/USCountyDataMap1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680894/Asset_075c58c5-b9e5-4da5-a2ed-54193040597f/USCountyDataMap2.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680894/Asset_4cb04363-d81a-493d-94b3-50d24f16ae05/USCountyDataMap3.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680894/Asset_19ee9c69-f594-4ecd-8d8d-8ebeb2ed5895/USCountyDataMap4.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680894/Asset_f7f0fb52-465b-4b61-bcbe-a0b9e8fbcfe6/USCountyDataMap5.png