Blogs & News
How to use Power Map in Microsoft Excel
23 March 2023
Power Map is a fantastic visualisation feature within Microsoft Excel, that enables you to transform your data into a format for virtual viewing.
It is a great feature for analysing data and gathering insights from your spreadsheets, as well as allowing you to relay information to different audiences.
What does Power Map do?
The Power Map feature enables you to turn your rows of data into a 3D interactive map, with the ability to filter data using three different filters:
What could I use Power Map for?
In a nutshell, Power Map aids you in discovering insights you might not see in your usual two-dimensional tables and charts.
You may want to use Power Map for the following:
Map your data – You can plot numerous (more than a million!) rows of data visually, using Bing maps in 3D format. You can take this from either an Excel table or a Data Model in Excel.
Discover your insights – You can use Power Map to view your data in a geographic space and view time-stamped data change over time.
Share your stories – You can capture screenshots and build guided video tours, which you can then share with your audience. The unique visuals will help to engage your audiences.
How do I create a Power Map?
Power Map is simple to use and launched easily when using Excel.
NOTE: Your data will need to have geographical properties and be in a table format or in a Data Model. For example, you could have your data in rows and columns that have names of cities, counties and postcodes etc.
Follow the steps below to create a Power Map.
1. In Excel, open a workbook that has the table or Data Model data you’d like to use.
2. Click any cell in the table.
3. Then click Insert >Map.
NOTE: Clicking Maps for the first time will automatically enable Power Map.
Power Map will use Bing, to geocode your data based on its geographic properties.
4. After a few seconds, the globe will appear next to the first screen of the Layer Pane.
5. In the Layer Pane, you’ll then need to verify that fields are mapped correctly. Just click the drop-down arrow if you see any incorrectly mapped fields and you’ll be able to match them to the right geographic properties.
6. When Power Map plots the data, you’ll see dots appear on the globe.
7. Click Next to start collating and presenting your data on the map.
If you cannot see the Power Map button in your version of Excel, take a look at this Microsoft help page.
If you have any questions about this or need assistance, then please contact the GCC Group Support Team on 0345 260 1151 or email@example.com
In our personal and business lives, we’re becoming more connected than ever. Microsoft 365 is the world-class cloud-based platform which helps you to achieve your goals from anywhere.
Microsoft 365 is a suite of apps bringing together all the greatest Office applications in one cloud-based platform, enabling your people to connect, collaborate and get things done from anywhere.
Applications that help you stay connected and get things done include:
Microsoft’s iconic word processing program allows you to create and share documents, now with intelligent document support.
Simplify complex data with the world’s most-used spreadsheet program.
Create and share outstanding presentations.
Bring everyone together with secure video & call conferencing, instant messaging, and collaboration.
Manage all your emails in one place.
- One Drive
Save files securely and access them at any time, from anywhere.
Create team sites to share information, files, and resources.
Plus, other useful applications such as Exchange, Intune and Azure Information Protection.
Speak to us today to find out how which Microsoft applications could be deployed in your business.