A Collection of Web Pages About Using Maps in Excel
Create a Map Chart – Office Support
Create a Map chart in Excel to display geographic data by value or category
You can use a Map Chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes.
Watch Doug from Office give a quick introduction to Map Charts…More at http://support.office.com
How to make a killer map using Excel in under 5 minutes with PowerMap plugin – Geoawesomeness
Many times it happens that you need to quickly visualize your data on a map but you don’t have a time to play for hours with ArcGIS or QGIS to make it look good.
In this tutorial I’ll show you how make an awesome looking map in Excel in under 5 minutes with a free plugin called PowerMap (formerly GeoFlow)…More at http://geoawesomeness.com
How to work with Maps in Excel 2013: step-by-step tutorial
Using the new Power View feature in Excel 2013, you can easily relate your data, e.g. sales reports, with maps (countries, cities, streets and specific geographical points).
Yes, now it is possible to work with nice charts that have Maps in Excel 2013. The latest version comes with the Power View.
It is an extremely powerful reporting tool. Sometimes we need to get sales reports and we want to identify regions and patterns of sales related to the customers…More at http://ablebits.com
3d Maps In Excel
How to Use 3D Maps in Excel – dummies
As shown, 3D Maps has been used to create a three-dimensional globe that shows these countries and their associated statistics.
The globe comes courtesy of Microsoft’s Bing search engine, so an active Internet connection is necessary.
To create the globe, follow these steps…More at http://dummies.com
Get started with 3D Maps – Excel
With 3D Maps, you can plot geographic and temporal data on a 3-D globe or custom map, show it over time, and create visual tours you can share with other people. You’ll want to use 3D Maps to:
Map data Plot more than a million rows of data visually on Bing maps in 3-D format from an Excel table or Data Model in Excel.
Discover insights Gain new understandings by viewing your data in geographic space and seeing time-stamped data change over time…More at http://support.office.com
Excel Heat Maps
How to ‘Heat Map’ Columns of Numbers in Excel | AccountingWEB
Excel expert David Ringstrom describes how you can apply heat map formatting to a column of numbers using the Conditional Formatting feature available on Excel’s Home menu.
It can often be difficult to get a measure of numbers in a spreadsheet, but Excel offers many data visualization techniques…More at http://accountingweb.com
How to Create a Heat Map in Excel – A Step By Step Guide
You can quickly create a heat map in Excel using conditional formatting. It enables you to visually compare data by assigning colors to it.
A Heat Map in Excel is a visual representation that quickly shows you a comparative view of a dataset.
For example, in the dataset below, I can easily spot which are the months when the sales were low (highlighted in red) as compared with other months.
In the above dataset, the colors are assigned based on the value in the cell. The color scale is Green to Yellow to Red with high values getting the green color and low values getting the red color…More at http://trumpexcel.com