What is Excel Power Map:
Microsoft Power Map in Excel is a three-dimensional (3-D) data visualization tool that lets you look at information across Geographical location in a handful of different representation.
Adding Excel Power Map from Add- ins:
By Default Map will be found under the “INSERT” tab. If Map is not present under “INSERT” Tab then you might need to activate it in Add-Ins menu. To do that go to
File -> options -> Add-Ins
From the manage drop down choose COM Add-ins as shown above and click GO button
Check the button for Microsoft Power Map for Excel and click ok button to activate it
Now, Excel Power Map will appear on the insert tab.
Data used for Creation of Power Map in Excel:
We will be using top 50 cities in the world and their corresponding density of population to explain this tutorial of Power Map in Excel. Our data is as follows
City | Density_of_Population |
---|---|
Mumbai | 29650 |
Kolkata | 23900 |
Karachi | 18900 |
Lagos | 18150 |
Shenzhen | 17150 |
Seoul/Incheon | 16700 |
Taipei | 15200 |
Chennai | 14350 |
Bogota | 13500 |
Shanghai | 13400 |
Lima | 11750 |
Beijing | 11500 |
Delhi | 11050 |
Kinshasa | 10650 |
Manila | 10550 |
Tehran | 10550 |
Jakarta | 10500 |
Tianjin | 10500 |
Bangalore | 10100 |
Ho Chi Minh City | 9450 |
Cairo | 9400 |
Baghdad | 9250 |
Shenyang | 9250 |
Hyderabad | 9100 |
Sao Paulo | 9000 |
St Petersburg | 8550 |
Mexico City | 8400 |
Santiago | 8400 |
Singapore | 8350 |
Lahore | 8200 |
Recife | 8050 |
Istanbul | 7700 |
Dalian | 7100 |
Khartoum | 6850 |
Rio de Janeiro | 6850 |
Monterey | 6700 |
Bangkok | 6450 |
Osaka/Kobe/Kyoto | 6400 |
Guadalajara | 5900 |
Athens | 5400 |
Ankara | 5300 |
Madrid | 5200 |
London | 5100 |
Tel Aviv | 5050 |
Sapporo | 5000 |
Buenos Aires | 4950 |
Moscow | 4900 |
Barcelona | 4850 |
Porto Alegre | 4800 |
Tokyo/Yokohama | 4750 |
Belo Horizonte | 4600 |
Fortaleza | 4550 |
Warsaw | 4300 |
Tashkent | 4150 |
Naples | 4100 |
Select your data:
Now you just need to select the data you want to map, in my case it would be the whole table, go to INSERT tab, and click on a “Map” icon. Click on “Launch Power Map” and here we go.
The Power Map window will pop-up on your screen. Excel Power map Plugin Automatically detects the city as Geography in “choose Geography” Layer.
If you want a flat map click on the “Flat Map” tab . As we are plotting the density of population across the world .We in deed require a Flat Map.
After choosing “the geography” click on the NEXT button in the bottom-right side of the page. You will be moved to choose the range. Now you need to select which data you want to visualize. Here check the Density_of_Population check box. Which plots the Density of population Across the City (Chosen Geography).
Below That there is a menu to select how you want to visualize the data. There are 5 options:
- Stacked Columns
- Clustered Columns
- Bubble
- Heat Map
- Region
Default will be stacked column. Click on Downward Arrow(Shortcut: Shift Down Arrow ) to View 3D view of power map in Excel.
Resultant power map in excel will be
Now the best way to present this data in Excel power map is bubble chart. click Bubble button in the below menu.
So the Resultant Power map in Excel will be
Represent Places by Different Colors in Excel Power Map :
If you want to Distinguish each and every city then Check the city Check box under the Range.
As the result every city is represented in different colors. So the Resultant power map will be
You can adjust the bubble size , Opacity and Thickness by clicking the settings button on the Top Right corner as shown below The size of the bubbles will change with the map scale so you can select “Lock current scale” , to make them look same when you zoom in or zoom out.
From the themes Tab you can also choose the Themes that you want as shown below
Now the Power Map in Excel is ready , we can present it directly in Excel to maintain the interactive feature or we can take a screen shot and present it in image format.