You can download the Excel file here.
So how do we visualize this data on a Map (using Power Map)?
It's amazingly easy.
You select the entire table, goto Insert Menu, click on Map and Launch Power Map.
You'll get a new window that looks like the one below.
The two most important parts are:
In the rightmost pane (shown in the immediate image above), tick Latitude and Longitude. And at the bottom of that pane, link them appropriately (select Latitude for Latitude and Longitude for Longitude).
Click on Next. Tick Population and Town.
And you'll get a beautiful map like the one below.
The populations are showing as data bars at the very location of each town. And you can zoom.
Placing the mouse pointer on any of the data bar will show you the full information for that data point.
Also let's turn on Map Labels so we can see the states and towns as they would show on a conventional map. Click on Map Labels on the menu bar.
You'll get something this cool.
And that's how easy it is to use Power Map in Excel 2013.
And to add more fun to this, we can change the way the map looks. Just head to Themes on the Menu bar. And try out the other themes.
Can you try guessing what theme I used for the following?
I'll be waiting for your answer...