🌍 How to make interactive Excel Map charts

Рет қаралды 284,167

Күн бұрын

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
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: 1drv.ms/x/s!AmxrofZZlZ-whMtzQ...
- How to Build Excel Interactive Dashboard: • 📊 How to Build Excel I...
- Get started with Power Map in Excel: support.microsoft.com/en-us/o...
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⌚ 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: • ❎ How to use Excel
🚩 Connect with me on social
- LinkedIn: / kevinstratvert
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🔔 Subscribe to my KZfaq channel
kzfaq.info?...
🎬 Want to watch again? Navigate back to my KZfaq channel quickly
www.kevinstratvert.com
🛍 Support me with your Amazon purchases: 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

Пікірлер: 177

@KevinStratvert 2 жыл бұрын

🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzfaq.info/sun/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

@pardeepchhikara2170 Жыл бұрын

Use correct map of India.

@BlackSeedOil20 Жыл бұрын

I need maps for commercial use. Can I download the ones I generate here?

@nonoobott8602 2 жыл бұрын

Just what I needed. Very explicit and easy to follow. You're phenomenal Kevin. Thanks for sharing

@buysmartter 2 жыл бұрын

I needed that a week ago. Seriously. This is mind blowing. Had no idea excel had those!

@kaisaorgusaar7989 6 ай бұрын

I did not know that map charts existed in Excel. I am mindblown! This is extremely useful!

@ramsesmedina3894 10 ай бұрын

Thank you for your straightforward explanations, I really appreciate it.👍

@junetorres4120 2 жыл бұрын

wow... Thank you kevin, now my presentation of data become better than before. I really love this... 😍😍😍

@Juan_ChoS Жыл бұрын

This is one of the best excel tutorials I've seen

@TylerStanczak 2 жыл бұрын

Never knew about this map feature in excel this is amazing! :)

@Aaronperiod 2 жыл бұрын

You have rocked out my world with this video

@tarunkataria9323 11 ай бұрын

Amazing! Was looking to learn this from long time... Found this to be perfect!

@hiddengem4293 2 жыл бұрын

Wow! Thank you for this valuable information!

@SavageGothamChess 2 жыл бұрын

Are you kidding me? Never knew this. Really love the animated 3D map. That was so cool. Awesome video.

@KevinStratvert 2 жыл бұрын

thanks, Hovindu! 👍

@johncheung4905 2 жыл бұрын

WoW !!! What an amazing presentation! Amazing! I love it !!!!!!!!!!!!!!!

@HarjeevanSingh-Tech 2 жыл бұрын

Wow I never knew this! Amazing video 😁

@joanhatcher1083 2 жыл бұрын

Wow! I didn't know this. Thanks for sharing.

@zephyrjohn879 Жыл бұрын

Straight to the point.

@samaiech7587 4 ай бұрын

Well done and very informative. Beats regular training from professional training centers as far as I'm concerned. THANK YOU!

@Adiroxy1 Ай бұрын

Thanks for a nice presentation. The globe is awsome!

@TaufiqAliMurtadho Жыл бұрын

Thanks Kevin, it helped me a lot

@cenevspeed 2 жыл бұрын

Fascinating Kevin! I did not know this was possible. And even if I did know how to do it, it would be tough to make it, but you explained it in a very simple way👍. The idea behind this is very interesting and can be used for Geography Projects. Thanks For The Tutorial😀 And again your thumbnail was ASTOUNDING and stood out from others in my feed... that globe behind you really enhanced the look of it and made it more catchy🔥. Keep it up🙏 You are almost at the BIG GUY (1 Million)!

@AvanishKesharwani 2 жыл бұрын

Extremely Thanks for the video. It is one of my better topic in Excel and your explanation made it best. I really like your video. I have never thinked of it earlier whether it is possible in Excel. Again, Many many thanks to you. 👍 :-)

@costond.dorsey4228 2 жыл бұрын

Great instruction!

@mustaro7792 2 жыл бұрын

Really fascinating 👍🏼

@user-ed4jm8bp9u 4 ай бұрын

Briliant well explained and easy to follow

@user-en6xs2nu7w 2 жыл бұрын

Nicely presented, Thanks for this unknown info on excel. keep this good work up✨

@thanhhung6201 2 жыл бұрын

Supper cool! Tks much, Kevin

@rocinante666 2 жыл бұрын

Great video!

@zippychan3252 2 жыл бұрын

Hi, Kevin, it is fantastic! 😊

@stellakiari7073 2 жыл бұрын

This is so cool.. Never knew about the map function in Excel..thankyou so much for the video.. Can't wait to try this

@KevinStratvert 2 жыл бұрын

Have fun!

@danhnguyen-mm2ue 2 жыл бұрын

did not even know Excel can do this !!!! thks

@bharatbhushantiwari2138 2 жыл бұрын

Love from india You are excellent

@anupsingh5858 2 жыл бұрын

Simply a WOW 👏

@chrislee3378 2 жыл бұрын

Did not know this, wow!!!

@prinfiniti Жыл бұрын

Awesome This is my favourite map

@vishsri Жыл бұрын

Awesome stuff

@cloudevops 2 жыл бұрын

Nice tutorial

@AndreaJD2B 2 жыл бұрын

I had no idea! I need some geo data to play with RIGHT NOW!

@tropolite 2 жыл бұрын

I still can't find Kevin's Cookies in Australia... Good detailed tutorial, nicely paced and well explained. Thanks

@kakanyerorobsonjimmy1593 2 жыл бұрын

Great video

@Darkslide820 Жыл бұрын

Damn this a lot of good info, never noticed there was a 3D map option (even though it's right there...). I love the drop down box idea to filter what continent shows up on the map. But since I'm not a fan of helper columns, I'll throw a couple suggestions out for anyone trying to copy this: 1) Instead of making the "Regions" column, you can paste a UNIQUE formula directly into the data validation setup, then the drop down list will only show the unique values from the actual data table Column A 2) Instead of adding the TRUE/FALSE column, when adding that FILTER table that pulls the relevant country and sales based on what's selected in the drop down box, make the criteria range (I think it's the 2nd portion of the FILTER formula, might be called "include") A:A= [the cell that had the drop down box]

@JustBlankNoInfo 2 жыл бұрын

I know your joking, right? Wait no! This is sick. I want that cookie btw. This is just a google map but totally in the next level! This was a dynamic tutorial, loved this! The video, the idea, the thumbnail, the headshot, the storytelling everything is the next level!!

@riro58 2 жыл бұрын

love from Bangladesh

@ahmedeid-bz8gd Жыл бұрын

PERFECT ONE

@merciexl21 2 жыл бұрын

For the list of regions( at 5:03), I would have used "unique" and "sort" to make it dynamic. Not so much new regions will be created thought… Very clever way to use filter, thanks for this interesting video Kevin!

@KevinStratvert 2 жыл бұрын

Good point!

@rotethongvanit 2 жыл бұрын

Great!

@benitalee9135 2 жыл бұрын

Thank you for sharing this amazing presentation Kevin, but for the filter function unavailable people, is there any other function instead?

@alienatedgurl 2 жыл бұрын

This why I subscribe to you

@cocngu427 Жыл бұрын

Thanks Kevin

@thenewyorkean Жыл бұрын

Kevin you transported me to a new dimension ! I have a question though: as we are now very accustomed to online spreadsheets, do you know if that kind of Excel data and visuals will be visible on the online Excel vession ?

@ruanthiart6849 2 жыл бұрын

@Kevin Stratvert, Firstly your tutorials are really precise and great! I am from South Africa, and would like to create a map for lets say only one City in South Africa , with all of its Suburbs , however I cannot seem to get the map working, could it be that the mapping is not set up for South African suburbs or am I expecting too much?

@Emansky84 2 жыл бұрын

"we at kevin cookie company dont use power bi. we are lords of excel" hahaha damn this is so good it's my goto channel while doing dishes. cleaning and learning at the same time hahaha

@totterva1869 2 жыл бұрын

I was not aware that Excel had a mapping feature - I already created my first map in Excel today

@jonicolton 11 ай бұрын

thank u

@yasironvideo Жыл бұрын

Thank you so much dear Kevin, this is quite closed to what I was looking for, except that I have geo coordinates and I want to plot location, but like you showed, I want to keep it dynamic and keep it in as a section in my dashboard (and not in a separate window the way 3d map does). Can you please help me achieve it. Thanks a ton.

@muhammadjawadkhan9841 Жыл бұрын

Hello Kevin, Thanks for such a nice and short video! I just have a quick question. Is it possible to know a density around let say certain miles of your data for e.g. I have a zip code and want to check if how many cookies are sold in a 30 miles radius? Thanks!

@groeisterk Жыл бұрын

Wow!!

@swastikszn1781 2 жыл бұрын

Great video Kevin!

@thequransignificance 2 жыл бұрын

Can't wait for 1 million subs! All the best Kevin!!!

@katrinagizellejavier3736 9 ай бұрын

Thank you for this Kevin! Is there a way where I can make the map present data based on a slicer clicked?

@TravellingTech 2 жыл бұрын

Today Love that intro part voice

@swastikszn1781 2 жыл бұрын

Congrats on 900k subs kevin! 1 million soon!

@prokorshopal4865 2 жыл бұрын

0:00 - Hi Kevin. 👋 12:53 - 573rd thumbs up from me. 👍 Cheers.

@faybe220 2 жыл бұрын

Hi Kevin, am a high school English teacher and I would really to learn how to create an animated test in video format using PowerPoint. For example, where for each question, the student is presented with two or more choices to pick one and then next question shows up. Could you kindly upload that sort of video next? Thanks a bunch!

@tarasherlock876 Жыл бұрын

Kevin, what if I need to create a specific map by region based upon the names of Markets? Example: I have a map of Michigan, and I have the image divided by East Mich, Mid Michigan, West Michigan with my markets Name East, Central and West. I want it to highlight that location when it's selected in my dashboard.

@Campdog44 2 жыл бұрын

Kevin really?! You're good man. Can you do this for one state and do townships using postcodes?

@vb2641 Жыл бұрын

Thank You very much for this Great Video. How to publish it online? In Google Slides for example You can publish presentation. Is there is such a feature in Office 365 to publish interactive map?

@dimitrisvaramentes1903 Жыл бұрын

Excellent! But, what version do i have to have iot activate the map option? I only get the basic pack of charts...

@edydarmadji3204 Жыл бұрын

Thanks Kevin. Please make a video about using Excel 2019/2021 with Argcis for Office embedded. TQ👍

@franklavery9149 2 жыл бұрын

Hi kevin does excel support UK regions and post/zip codes?

@easyoffice5016 2 жыл бұрын

Sir Which video editing tools you are using for this tutorials ??

@swastikszn1781 2 жыл бұрын

Amazing video+Great thumbnail too!

@lauuruguay 2 жыл бұрын

I have version 16.59 of Excel BUT don't have 3D Maps. Which version has 3D Maps? Thank you for all your amazing videos by the way!!!

@marceljunioregondi5594 2 жыл бұрын

Is this on all excel versions or which version did the feature come into play.

@tango31415 2 жыл бұрын

Is there a way to use the Slicer to show say, type of cookie sold per state? Can you do a video on that?

@sediksekkour8545 Жыл бұрын

Bonjour Kevin, merci pour la vidéo, est-il possible d'utiliser excel 3D pour liéer des données à des étages d'un immeuble ? mon périmètre est bien plus petit qu'une ville, une région... Merci d'avance de ton retour. Bien cordialement.

@Jack-px9mh 2 ай бұрын

Is there also the option to drill down to the level op cities within regions and countries?

@skmaheswaran 2 жыл бұрын

This is really good Kevin. I have a scenario where I need to read the value of a cell based on color on another cell. without VBA can we do that. I am aware of Get CELL Name Manager function but it is not giving me the expected results. Could you pls help

@jaijagannath810 Жыл бұрын

Hello Mr. Kevin, Kindly let me know which version of excel can be used?

@yulinliu850 2 жыл бұрын

So cool. 👍😊💐

@rathisakphansavath5829 2 жыл бұрын

Awesome!

@DrPixel-mt3qd 2 жыл бұрын

Can you use a map of your choosing instead of the one provided?

@AngerTroll 5 ай бұрын

Could you do a tutorial on heat mapping locations outside of geographical data? Like warehousing storage locations?

@johnfairhurstReviews 2 жыл бұрын

It'll need the data analytics add-in active before the 3d maps option works - no biggie but not like you to miss a step 😊👏

@tiagosoares3953 Жыл бұрын

Can i make a map graph from the blueprints of the place i work. For example, i work at a factory that has several rooms. The ID, Pintura, Soldadura, Desmontagem final, Subconvintos móveis, etc. I want to make a map, but instead of the map of the countries, i want the map from the blueprints.

@martinbenum5653 Жыл бұрын

Hi Kevin Not sure if you will read this but thought I might try. I am trying to figure out how to get access to power map but you need a work account, which I do not have. I am trying to find or see if there are any work arounds for that kind of issue. Would be nice if there was a way to get around it. Not sure if there is or if someone has created an answer to that. It is the same for all MS power apps. I am retired and like to learn new things with all the new tools that I did not get a chance to when I was working. My question is would you know a way around this? Might make a good video!

@rnvf.1564 2 жыл бұрын

Liked it before I watched, cause I know it’s high quality!

@emontino 2 жыл бұрын

Hi Kevin can you also put a community where we can ask questions?

@aim4awesomeness 2 жыл бұрын

Hi Kevin - possible to have a review of Kaizala? Cheers :0)

@shahzaibkhattak3631 2 жыл бұрын

Are you using microsoft 365 as i don't have filter function in Ms 2016.

@aveerajsharma 2 жыл бұрын

Ohh!! Wow!! 👏

@uoahsfsdif 2 жыл бұрын

When I try to export a time lapse as a video, it get to 99% then stops. No error messages, it just say "Creating your video. this could take a few minutes..." . Anyone know what's happening or how to fix it? Is it just too much data?

@KamaleshMohanta Жыл бұрын

How I can use my own map in this? For example I have my cadastral village map

@m.monteil5736 2 жыл бұрын

I do not have the map option in Excel. Is there a way to add it?

@ewmurphy 2 жыл бұрын

You can also use dynamic array UNIQUE/SORT function for select REGION dropdown.

@KevinStratvert 2 жыл бұрын

Thanks for sharing! 👍

@fathinnabilah3816 Жыл бұрын

If I want to look just in Indonesia, can I use the same concept?

@persl8 Жыл бұрын

Is there a way to create my own geographic area to show on map?

@katnisskatiebell8681 Ай бұрын

Is it possible to filter by city or town? I wanna show a map where I can put a pin to show our employees from all around the world, filtered by city or town.

@thomasjstrouse6350 2 жыл бұрын

I tried to create a 3-D dynamic map, but the globe is not updating when I a new region, for example, is selected. Is there a way to refresh the sheet?

@Doglapan_Pro Жыл бұрын

can we do just opposite like turn map location into excel sheet data.

@kaffepojke 8 ай бұрын

Is there any way to create an interactive map from a mailing list with more than 100 unique entries, or possibly create 1 map for each 100 entries and then join after the fact? Thank you.