Hannah Pearson May 30, 2022

Just How Easy is using Power Maps?

Everyone knows about the incredible business capabilities of Excel. Although considered an application for “number people” it can be a powerful visualization tool. Take Power Maps – the handy tool that maps data. We wrote a blog several weeks ago about how to map data using Excel 3D Power Map. Given we are constantly banging on about how easy to use Excel is, we decided to put it to the test.

How to Make a 3D Map in Excel

To test it out, we gathered our google analytics data for visits to our Australian site by country and collated it into a simple Excel workbook. For Power Maps to be effective, geographic data needs to be formatted as so. To do this convert your data to a table (either under the home or data tab).

How to convert data to a table

How to convert data to a table

Then select the data you want classified as geography and navigate to the data tab. Then click on ‘Geography’ under data types.

How to convert data to geography

A small map icon should appear in the cell indicating that Excel recognises the location.

Map icon geography

To map the data, select both the geographic and user columns and click on the ‘insert’ tab. Under charts, select the ‘Maps’ option and a map containing your data should appear!

3d power maps

power maps

 

You can alter the map under the ‘Chart Design’ tab.

For more Excel tips and tricks, join our Excel course.

Related Topics

Contact Us

Why Nexacu? 

Valued by Individuals

4.72 / 5
Over 78323 Reviews
good
Purbaj - Power BI Beginner Remote West, .
Very good communicator, makes training environment very comfortable.
Paul - Power BI Beginner Perth, .
Well presented. Thanks.
Beverley - Power BI Beginner Perth, .
Perry was great. Explained everything from start to finish in fantastic detail. Easy to follow and would recommend to anyone at any stage in their Excel to PowerBI growth phase.
Ben - Power BI Beginner Perth, .
Very informative and useful training session for Power BI beginners. Good pace and level of information.
Sonya - Power BI Beginner Perth, .
Well explained and easy to understand. Really enjoyed the information given
Janet - Power BI Beginner Perth, .
Excellent Training . Very insightful
Moushmi - Power BI Beginner Perth, .
Patient and knowledgeable trainer
Mark - Power BI Beginner Perth, .
Excellent presentation, appropriate for the level. Great basics for next level. Thank you for sharing your knowledge.
Marcell - Power BI Beginner Brisbane, .
I was happy with the clear and concise manner in which the contents was delivered. I learnt heaps and ready to give it a go!!
Tamara - Power BI Beginner Brisbane, .
no feedback required all was really good. Steven was very engaging and patient with all students and explained things very well and worked at a good pace.
Ashle - Power BI Beginner Brisbane, .
Thank you!! Learnt a lot, excited to play around with Power BI :)
Bree - Power BI Beginner Brisbane, .

Trusted by Business

Awards and Accreditations

Follow us