Pinterest Pixel

3D Maps In Microsoft Excel

Bryan
Did you know that you can create a 3D Map in Excel to visualize your geographic and temporal data?
3D Maps In Microsoft Excel | MyExcelOnline 3D Maps In Microsoft Excel | MyExcelOnline

You will be blown away by what it can show you, as it offers you a different perspective as compared to tables and charts!

We will be using data from a list of Power Station examples that we have downloaded from MicrosoftPower%20Station%20Sample.xlsx. This is our sample table with geographic location and specified times:

3D Maps In Microsoft Excel

3D Maps In Microsoft Excel | MyExcelOnline

Download excel workbook3D-Maps.xlsx

 

STEP 1: Ensure you have clicked on your data. Go to Insert > Tours > 3D Map

3D Maps In Microsoft Excel

 

STEP 2: All of a sudden you have a bare 3D Map!

Let us do the following, drag the following fields:

  • Capacity (Megawatts) to Height – to show a tall bar per location according to the value
  • Company to Category – to color code the bar according to the company’s portion
  • Initial Date of Operation to Time – you will see something cool later, wherein an animation of a timeline will be generated!

3D Maps In Microsoft Excel

And just like that your 3D Map is now ready for your analysis!

3D Maps In Microsoft Excel

STEP 3: Wait there’s more! Go to Home > Tour > Play Tour

You will see an animation of the timeline on the growth of Capacity has went over time per location!

3D Maps In Microsoft Excel

See our recording below to see the timeline in action!

 

How to Create a 3D Map

 

If you like this Excel tip, please share it
3D Maps In Microsoft Excel | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  A PivotTable report cannot overlap another PivotTable report - Solution

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...