How to Turn Data into Interactive Map Chart in Excel

In this step-by-step tutorial, learn how to take data and transform it into a visual map using Microsoft Excel. First, we look at how to create an Excel map using two columns of data. Next, we explore how to create a dynamic map that you can interact with using a drop-down list. With a dynamic map, the maps view changes based on the user’s selection. Last, we look at how to build 3D maps in Excel using Power Map, which allows you to explore your data using multiple fields, times, and filters.

• Additional resources
  • Sample spreadsheet I used to follow-along
  • How to Build Excel Interactive Dashboard
  • Get started with Power Map in Excel
• Timestamps
  • 0:00 Introduction
  • 0:55 Insert a basic map
  • 3:26 Map optimizes view based on geographies
  • 3:57 Create a dynamic map
  • 9:06 Move dynamic map to interactive dashboard 10:12 Visualize data with a 3D Power Map
  • 11:34 Animate 3D map
  • 12:21 Wrap up