If you want to Distinguish each and every city then Check the city Check box under the Range.Īs the result every city is represented in different colors. Represent Places by Different Colors in Excel Power Map : So the Resultant Power map in Excel will be Now the best way to present this data in Excel power map is bubble chart. Click on Downward Arrow(Shortcut: Shift Down Arrow ) to View 3D view of power map in Excel. There are 5 options:ĭefault will be stacked column. Which plots the Density of population Across the City (Chosen Geography).īelow That there is a menu to select how you want to visualize the data. Here check the Density_of_Population check box. Now you need to select which data you want to visualize. We in deed require a Flat Map.Īfter choosing “the geography” click on the NEXT button in the bottom-right side of the page.

As we are plotting the density of population across the world. If you want a flat map click on the “Flat Map” tab. Excel Power map Plugin Automatically detects the city as Geography in “choose Geography” Layer. The Power Map window will pop-up on your screen. Click on “Launch Power Map” and here we go. 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. 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. Data used for Creation of Power Map in Excel: Now, Excel Power Map will appear on the insert tab.

To do that go toįrom the manage drop down choose COM Add-ins as shown above and click GO buttonĬheck the button for Microsoft Power Map for Excel and click ok button to activate it If Map is not present under “INSERT” Tab then you might need to activate it in Add-Ins menu. Adding Excel Power Map from Add- ins:īy Default Map will be found under the “INSERT” tab.

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. Tutorial on Excel Trigonometric Functions.Tutorial on Excel Statistical Functions.Tutorial on Excel Mathematical Functions.Tutorial on Excel Information Functions.Tutorial on Excel Engineering Functions.

Heat maps in excel