Create Beautiful Map with Power Map in Excel

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

Power Map in Excel

From the manage drop down choose COM Add-ins as shown above and click GO button

Power Map in Excel 2

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.excel power map power map in excel 3

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

CityDensity_of_Population
Mumbai29650
Kolkata23900
Karachi18900
Lagos18150
Shenzhen17150
Seoul/Incheon16700
Taipei15200
Chennai14350
Bogota13500
Shanghai13400
Lima11750
Beijing11500
Delhi11050
Kinshasa10650
Manila10550
Tehran10550
Jakarta10500
Tianjin10500
Bangalore10100
Ho Chi Minh City9450
Cairo9400
Baghdad9250
Shenyang9250
Hyderabad9100
Sao Paulo9000
St Petersburg8550
Mexico City8400
Santiago8400
Singapore8350
Lahore8200
Recife8050
Istanbul7700
Dalian7100
Khartoum6850
Rio de Janeiro6850
Monterey6700
Bangkok6450
Osaka/Kobe/Kyoto6400
Guadalajara5900
Athens5400
Ankara5300
Madrid5200
London5100
Tel Aviv5050
Sapporo5000
Buenos Aires4950
Moscow4900
Barcelona4850
Porto Alegre4800
Tokyo/Yokohama4750
Belo Horizonte4600
Fortaleza4550
Warsaw4300
Tashkent4150
Naples4100

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.

excel power map power map in excel 4

 

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

excel power map power map in excel

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

excel power map power map in excel 7

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

excel power map power map in excel 8

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

excel power map power map in excel 9

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.

previous small power map in excel                                                                                                                next small power map in excel