🌍 How to Turn Data into Interactive Excel Map Chart
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: https://1drv.ms/x/s!AmxrofZZlZ-whMtzQ49KJE9lQcbhag?e=87s4ZC
- How to Build Excel Interactive Dashboard: https://youtu.be/MTlQvyNQ3PM
- Get started with Power Map in Excel: https://support.microsoft.com/en-us/office/get-started-with-power-map-88a28df6-8258-40aa-b5cc-577873fb0f4a
⌚ 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
📃 Watch related playlists
- Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🚩 Connect with me on social
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert
Видео 🌍 How to Turn Data into Interactive Excel Map Chart канала Kevin Stratvert
👋 Additional resources
- Sample spreadsheet I used to follow-along: https://1drv.ms/x/s!AmxrofZZlZ-whMtzQ49KJE9lQcbhag?e=87s4ZC
- How to Build Excel Interactive Dashboard: https://youtu.be/MTlQvyNQ3PM
- Get started with Power Map in Excel: https://support.microsoft.com/en-us/office/get-started-with-power-map-88a28df6-8258-40aa-b5cc-577873fb0f4a
⌚ 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
📃 Watch related playlists
- Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🚩 Connect with me on social
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert
Видео 🌍 How to Turn Data into Interactive Excel Map Chart канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![📊 How to Build Excel Interactive Dashboards](https://i.ytimg.com/vi/MTlQvyNQ3PM/default.jpg)
![How to Create a DYNAMIC Map Chart With Drop-Down (works with ANY Excel version)](https://i.ytimg.com/vi/EoKoN1q2cTk/default.jpg)
![Create a Map Chart in Excel](https://i.ytimg.com/vi/omMiBZ3mxxE/default.jpg)
![](https://i.ytimg.com/vi/RLcQSoou-_g/default.jpg)
![👑 10 BEST FREE Web Sites You Should Use in 2021](https://i.ytimg.com/vi/qdezE6KguGU/default.jpg)
![How to use Power Pivot in Excel](https://i.ytimg.com/vi/rB_IiYbOo7w/default.jpg)
![How to Make Animated Cartoon of Yourself in PowerPoint](https://i.ytimg.com/vi/7KXrLkghRfg/default.jpg)
![Top 20 Microsoft Excel Tips & Tricks](https://i.ytimg.com/vi/AOPa7ORJj4Y/default.jpg)
![Secrets to Building Excel Dashboards in Under 15 Minutes!](https://i.ytimg.com/vi/9p6tWCHbtPQ/default.jpg)
![Excel Heat Map Chart Fast & Easy | State + Zip | Postcode + Country | Australia + Indonesia + World](https://i.ytimg.com/vi/CrinvmfTtuI/default.jpg)
![How to create a Dynamic Map Chart with drop down in Excel 🗺 Excel Map Chart India](https://i.ytimg.com/vi/kKiWCxQH89E/default.jpg)
![Dynamic Filled map in Excel | Connect with Wikipedia page to get population Data](https://i.ytimg.com/vi/oPLl1SLMKbU/default.jpg)
![👩💻 Python for Beginners Tutorial](https://i.ytimg.com/vi/b093aqAZiPU/default.jpg)
![Smart Excel Pivot Table Trick - Choose Your KPI from Slicer (Excel Dashboard with DAX)](https://i.ytimg.com/vi/Q3YY1Ue9j-k/default.jpg)
![Excel Dynamic Filled Map Chart with Power Query](https://i.ytimg.com/vi/bMJyPbUxjYc/default.jpg)
![🔎 XLOOKUP in Excel Tutorial](https://i.ytimg.com/vi/HXU7lsd0ftA/default.jpg)
![Create INTERACTIVE Excel Dashboards With Option Buttons | How to use Radio Buttons](https://i.ytimg.com/vi/oSTgFUiRDGI/default.jpg)
![How to Make a Google Map from Excel](https://i.ytimg.com/vi/SLMzhOoA29M/default.jpg)
![How to create map chart in excel](https://i.ytimg.com/vi/mXStpvbg24g/default.jpg)
![How to Import Data from the Web in Excel](https://i.ytimg.com/vi/6hMxzxhuD2A/default.jpg)