How to Create a DYNAMIC Map Chart With Drop-Down (works with ANY Excel version)

[@LeilaGharani]

Create charts that wow your audience. Learn the secrets now-start today! 👉 link.xelplus.com/yt-g-dyn-maps-charts-course Grab the file I used in the video from here: pages.xelplus.com/dynamic-maps-file

[@88Gymgeek]

Speaking as a qualified professional accountant here, your videos are invaluable. I am learning and adding so many new things to compound my already existing knowledge on excel. You are a godsend. Thank you so much!

[@juancarlosmartinez3621]

Amen

[@Lucky-ny7vf]

Speaking as a qualified professional accountant? Maybe should know about her.. who is she 😅..

[@taffyjones1642]

For most of us who thought we knew Excel, she is really kicking your ass! Great video as usual.

[@safaroneall]

Agree

[@sarvesezio]

Thanks!

[@LeilaGharani]

Thank you very much!

[@sarvesezio]

@@LeilaGharaniI want your opinion on using macros in powerpoint. Is macros need for powerpoint. Thank you for your videos. Your videos are awesome. Thank You

[@TS-yy6jb]

You are an excel hero. Of all the channels on KZbin you are first one I have subscribed to in all these years cause I feel you are truly adding value in this space and deserve very rightfully all the encouragement and support.

[@LeilaGharani]

Oh wow, thank you for the kind words. It's great to have you here :)

[@surfmarko]

Where have you been all my life? THANK YOU!

[@skylucrew6377]

Leila you are an inspiration...your english is perfect and very well understandable, your tutorials are clean and responding to every day needs for an analyst like me.. and you are also beautiful.. 😁.. congrats from Italy..

[@mohamedbouferghous7255]

Je connais juste quelques mot en Anglais mais tellement vos démonstrations sont clairs que j'arrive à saisir vos explications - Merci Madame.

[@LeilaGharani]

That's great. Thank you!

[@francisgremillet7546]

Leila, I'm not gonna be very original in my comments. I've never seen such a good Excel teacher!!! Congrats and pls keep on publishing tutos

[@LeilaGharani]

That's an honor! Thank you.

[@orelreshka81]

The best video lately on KZbin. You are very talented, I like how you competently educate. Thank you. You are my inspiration. Greetings from Ukraine.

[@LeilaGharani]

Thank you for the very kind words. I am glad you find the videos useful. I don't think I have much talent actually, just practice :) and I could definitely use more practice. Thank you for your support, all the way from Ukraine.

[@BiancaAguglia]

@@LeilaGharani Practice, curiosity, a problem solving attitude, dedication, hard work ... those are the some of the things that brought you to this level of expertise. The fact that it's all driven by a passion for sharing what you know and helping others, that's what makes you stand out. ❤️ Keep up the wonderful work.

[@doylemullins1788]

This is a very creative way to demonstrate very pertinent data in a unique way. I work for a venue company and can see this used to show revenue, cost, and attendance by area. This will be a huge asset to help explain how people move and spend money throughout an event.

[@LeilaGharani]

That's a great idea!

[@subhasissingha878]

This is not only learning it is also being motivated to beginners. Thank you . From India.

[@mytungkai]

I just spent 17mins ++ of my productive time on great learning. Very informative. Thank you so much.

[@bsf4276]

You can also hold shift to keep the ratio locked when draging pictures

[@aesop82245]

you are such a genius never seen anything this awesome

[@AdamSmith-me7uk]

5toplmnbn. . . X,,zy880oo998opl ..mmkm pi I'll rkd8uj

[@patrikw]

Super powerful! I love digging through your older videos, there's sooooo much knowledge in them.

[@marcelojtavella6315]

Well done, Leila! You are clearly an Excel wiz! Extremely clear and useful. Thanks!

[@LeilaGharani]

My pleasure Marcelo. Glad you find the tutorials useful.

[@bbasmdc]

Found this by accident and I want to congratulate you for choosing a really useful topic, with enough detail to be useful, but not too long to be boring. Very well paced and clearly explained. Thank you.

[@LeilaGharani]

I'm glad you find it useful :)

[@chrismo5555]

Amazing. Definitely using this at work! A little twist that I’ll do is when highlighting the largest value, I’m going to make the series value 5% larger, then put it behind the original series, to make it look circled. Love your videos!

[@LeilaGharani]

Very nice trick Chris. Thanks for the input.

[@jebat92]

Hi Leila. Just wanna say a very big thank you for making such wonderful educational videos. Your explanation have always been easy to understand. As I master some areas of excel which I did not know of or weak at, I recently conducted a sharing session with my team so that we can all benefit to improve productivity and efficiency while using excel. Thank you and keep it up! 👍 👍 👍

[@NGAsefa]

Dear Leila, thank you for demonstrating this wonderful combination of map and scatter plot.

[@LeilaGharani]

You're very welcome! Glad you like it.

[@ngasefa1162]

Maybe a related question to your presentation; I was using geographic heat map excel add-in for creating a map for the data I have. Can you explain to me how to add the color gradient legend?

[@LeilaGharani]

Is this a third-party tool? or are you referring to the new Excel 2016 map? For Excel 2016, you should be able to adjust that - but I wouldn't know about the third-party tool...

[@ngasefa1162]

Thank you. Yes, its an add-in for excel 2013 or newer version. This 5-minute illustration, by Computergaga, can explain what I want to ask. kzbin.info/www/bejne/p4CoqHWforJ_b7s

[@kabangukabangu2529]

You are now my Excel teacher

[@frank431]

Thank you Leila so very much for your excellent presentation skills and depth of knowledge in data analysis and display. I have been using spreadsheets and writing macros since VisiCalc and I thought I was pretty good at it. I've seen work from the pros and I'm not a pro, but I guess I'm as good at it as I am because I enjoy it just as much as you obviously do. But Leila, what I've seen and learned from your videos would humble the pros and makes me feel like I'm working at a grade 3 level compared to your PhD. I wish I had more time in my day to implement your lessons - I only have one project right now, but I want to try your techniques just to share in the obvious joy you bring to the subject. Please keep making these videos and teaching us old guys new tricks.

[@LeilaGharani]

Thank you Frank! I‘m very happy to hear you find the tutorials useful. I agree - there is so much to Excel which keeps it all interesting - The learning doesn’t end :)

[@manjityadav24]

Explained very simply and intelligently. Really helpful. Awesome...

[@LeilaGharani]

I'm glad you find the tutorial helpful!

[@lianchingyap5023]

You are our Excel Heroine! Most of my excel knowledge are came from you! Thank You!!

[@LeilaGharani]

My pleasure. I'm glad the tutorials are helpful.

[@enquirygametechnologymetho2271]

What a great way you have, technique to teach! your voice is "peace". Thanks Leila, I was looking for a long time to do a map for our ENQUIRY workshops participants around the world. And this made it!!!

[@LobanRahman]

So clean and simple, yet such a perfect output. Love it!

[@businesswithchina23]

your free lessons save me life. Thank you Leila

[@shamsheer7689]

This is one of your best videos I have been following....

[@alfredalmario2503]

Oh men i’ve been looking for years on how to do this in excel.. thank you so much for sharing this;)

[@LeilaGharani]

My pleasure Alfred. Glad it's helpful.

[@senthilkumarmanoharan6652]

Oh my God are you real. I have never seen anyone explain it so good .

[@flevinpatel4690]

Keep it up Ms. Leila you are helping a community a lot. Thank you very much

[@MauiRivera]

Basically everything you can visualize in Power BI can be done in Excel as well! So smart! Thank you for sharing this! 👏

[@adityachauhan8262]

I don't understand , why KZbin didn't recommend you earlier....you are awsome!

[@LeilaGharani]

Glad you're here now 😊

[@ManjuSharmaksa123]

Thanks again Leila for teaching more in excel. you are simply remarkable tutor.👍

[@LeilaGharani]

You're very welcome. Glad you like the tutorial.

[@yashsharaf8819]

Used it in my company's dashboard. What a time I saw this video. Awesome and Thank you.

[@LeilaGharani]

My pleasure. It's great you could apply it at work right away.

[@manishagupta6908]

Your Videos are simply amazing. You are an inspiration Leila. Thank you for sharing such insights in simple terms and helping lot of people excel in their work.

[@LeilaGharani]

You're so welcome!

[@nasimhomayouni7435]

I don't know what should I say... you are incredible... many thanks for your great video

[@mrCetus]

Thank you for such useful and easy to follow videos. This is the 3rd one that I have watched and I have so much more knowledge on Excel after watching your instructional lessons.

[@darrenvick4259]

As always...an excellent video. If you have an Excel problem check out Leila's videos...no one else comes close.

[@victoriac1156]

I love all your videos Leila, I only recently found your channel but now I am a keen follower :-) I am now also checking all your resources. Thank you very much, great work!

[@LeilaGharani]

I'm glad to hear that. It's great to have you here.

[@cnstantinoschronakis7743]

Your videos are the epitome of professionalism. Excellent work!

[@GoldAsH76]

💜 from India & thankyou for such clean & clear creative content

[@CarlosChicaVilladiego]

I wish KZbin had an "I loved it" button. Really good stuff!

[@saichand5171]

Great gods work you r doing helping us on finding a better way of creating dashboards and keep on updated on what we can do it in excel without any coding vba or macros. God bless u for doing a great work..

[@icedalpha5794]

I am trying to follow. It's a great course, but I'm getting lost when I have to put in =sumifs( when I select my ranges, I end up with zero after I hit enter). Please help! I'm totally lost.

[@VSP4591]

Very ingenious, congratulation Leila.

[@philvuk]

My god your way of explaining makes Excel so easy to understand and willing to practice ! Thanks a lot !

[@Jay-Atom50]

This is incredible. I thought I’d have to learn programming to do these things. I just wish I had seen these videos earlier so I could have used them in so many situations but it’s never too late to learn I guess. Thank you for your great work

[@LeilaGharani]

Glad it was helpful! It's never too late to learn!

[@christoskonstantinou1074]

A similar lesson about dynamic maps was my first contact with Leila's channel. Always perfect!

[@LeilaGharani]

Thanks Christos :)

[@Vandalfoe]

Very, VERY nice!

[@kutub52]

You are super awesome, believe me these tips are helping a lot of people may God bless you

[@rohilla71]

Marvellous use of Scatter Plot 👍🏻 You're a Doctor of Excel 🤠

[@sguchait]

You are simply Awesome Leila. I will use this today to represent the region wise values for our Org. Thank you so much.

[@LeilaGharani]

You're very welcome. Glad it's helpful for your work.

[@StevenWan11]

How am i only seeing this now.... 2 years behind... this is just genius! thank you!

[@michaelgnanam]

So impressed at your knowledge, not just for Excel, and ever grateful for your sharing. Learnt so much!

[@patricksoo]

I just bumped into your tutorials, and I find it REALLY REALLY cool!!! And very very very easy to follow! Keep it up!

[@waeltag123]

Awesome :) I tried by myself ......it worked flawlessly. Many thanks

[@LeilaGharani]

Most welcome 😊

[@patriceairoldi]

Thanks Leila for that great video, I did that dynamic map on Excel by following the video and it's working very fine !!! But sometimes it goes a bit fast, so I had to stop the video and then continue. But that's a detail, you do a great great work !!!

[@LeilaGharani]

Glad it worked out Patrice.

[@jiajiaphotography]

Lelia, you are super smart! Learned so much from your video. THANK YOU!!!!

[@LeilaGharani]

Glad it was helpful!

[@PANDOUGEN]

By far one of the best! excellent work!

[@LeilaGharani]

I'm happy to hear that!

[@emmanuelle8032]

My new reportings are thanking you so much Leïla ! ;)

[@ryanbarreto5048]

Excellent Video for creating a dynamic map chart with drop-down. Very well explained. It was easy to understand. This video was very useful.

[@Ryuzakary]

I can't believe she's giving us all this amazing intel for free.

[@sundararamanramanathan8940]

Excellent video and tip. Simple, powerful and sharp. Thanks Leila.

[@ethan073]

This is so badass. I already learned several basics in this video that are going to make life easier for me, too. Good job explaining what you are doing and why. I’m checking out your other videos now.

[@LeilaGharani]

I'm glad to hear the video is useful Ethan. Great to have you here.

[@Wulandari-gr2se]

Hi Leila, thank you so much for this. I had searched for this kind of short but clear tutorial of dynamic chart. 😘

[@LeilaGharani]

Thank you. I'm glad you like the tutorial :)

[@lesleywells3497]

I am so grateful for your work and teaching channel! Thank You!!

[@sooryashakthi]

Excellent representation

[@ksdsurf]

Leila, this is fantastic video to learn new skills. Thanks a lot!

[@LeilaGharani]

You're very welcome!

[@shameemnassiree2780]

Each and every video of yours is superb!! We all learn it so easily.

[@LeilaGharani]

I'm very happy to hear that Sami! Thanks for your support.

[@shameemnassiree2780]

Leila Gharani actually I should be more thankful that you are taking your time out and educating us.

[@irfanmansoori3060]

Leila, ur knowledge is too good and is very helpful.. Thank you..

[@LeilaGharani]

Glad it was helpful!

[@markwalton9702]

This is so great, I am going to use it to map out our garden . . . The wife likes everything labeled, this will take it far beyond that !!

[@LeilaGharani]

Wow, that must be a great garden :)

[@markwalton9702]

@@LeilaGharani It is approximately 35 x 80 m with 19 brick raised beds. I have already installed the steel posts with backing to put the map in place, it is also for when guests and family come over, they can go to the garden ledger (your map) and find things easily. Thank you very much for all the so wonderful work that you do in helping others.

[@lionelbogora1392]

You are the best ever. you made it so simple and motivating to learn.

[@LeilaGharani]

Thank you for the kind words! I'm glad you find the videos useful.

[@monte4955]

Great Video Leila. Never used one of these before thanks for showing how to do it. I like your approach on how you break it down and all the finer details that really add to little tips and tricks along the way. Thanks again. Monte

[@LeilaGharani]

Glad you like it Monte :) Thank you for your comment.

[@petemenhennet9792]

Great explanation. Now I know how to do this. You're really good at explaining, Leila!

[@LeilaGharani]

Glad you find it easy to follow :) Thanks for your support.

[@petemenhennet9792]

@@LeilaGharani I'm working my way through all the videos and picking up a lot of good ideas. Thanks for the hard work I know you must have put into making these.

[@waqasishaq5994]

Awesome work and the way you explained is amazing .. very smart and knowledgeable..

[@basketballeko588]

Very simple and straight forward!

[@deyokainspires3444]

Hi Leila. This is an awesome work and an insightful tutorial. Really appreciate. Keep it up

[@meddah]

Great work done! Content, duration of the video, how you deliver it, ... Perfection!

[@LeilaGharani]

Wow, thanks!

[@TheScottmcke]

This was exactly what I was looking for! Thank you for the step by step method!

[@bronwynclarke7368]

One of the best demo's I have ever seen //// WOW!!!!!!

[@mexexo]

Simple, Elegant & Easy to create. Thank you very much.

[@marcustorres100]

Thank you very much for this video! Greetings from Brazil!

[@LeilaGharani]

My pleasure. Hope it will come in handy.

[@philbrookes1]

Brilliant stuff and so easy to follow your step by step guide!

[@LeilaGharani]

Great to hear, Phil!

[@kumarym9312]

I really love your videos . I am so happy to see your videos Love you

[@LeilaGharani]

I'm glad to hear that :)

[@kumarym9312]

Thank you

[@nevermind4780]

I don't know what should I say because your each and every videos and explanations are above imagination

[@LeilaGharani]

Thank you!!!! I'm very glad to hear you enjoy the videos :)

[@ShirazMistry]

Thank you for such useful and easy to follow videos. This is the 3rd one that I have watched and I have so much more knowledge on Excel after watching your instructional lessons.

[@Hermitagup64]

That is very good tutorial, easy to understand and apply. Thank you Leila!

[@LeilaGharani]

Glad you think so!

[@mdhafizhasan755]

Excellent. Many thanks for making so wonderful and effective videos

[@MrEdybriones]

You make things look so easy! Thanks Leila!

[@legojenn]

Thanks for this. Your video came up in suggestions. It was perfect timing. I was stuck on the selection criteria. Pointing me towards SUMIFS made all the difference.

[@aramroshani6197]

No word for appreciation of your great job. Thanks

[@1gopalakrishnarao]

Thank you very much Madam. Once again doing great job, in explaining the dynamic Map chart . Really you are a genius in Excel Madam. I am very lucky indeed to view all your videos, and waiting eagerly to learn something in every videos. A big Salute to my beloved and beautiful teacher with great innovative ideas.

[@LeilaGharani]

Thank you very much Gopala for the extra kind words. Very happy to hear you like this video. Thank you very much for support and for dropping by.

[@tiffanym8720]

thanks Leila. your video is always useful and applicable to our work. I could apply this to other analysis as well:)

[@LeilaGharani]

Glad it was helpful!

[@rahulmoghe3899]

This is an excellent work around, and very nicely explained too. Thanks for posting this video!

[@LeilaGharani]

You're very welcome!

[@ennykraft]

I once did that for all the countries in EU. Took me ages to get the coordinates right.Some of these countries are tiny. With a map like this where the regions are larger it's much easier. It was such a pleasant surprise when they added maps to the charts but then getting the names of the places right is a huge PITA if you aren't using English (for example it has to be Greece instead of Griechenland or it won't show up whereas most other countries are fine in German). Plus I like that everybody can see the bubble chart.

[@LeilaGharani]

Haha, I've been there. Years ago I would spent hours tweaking such charts and in the end they anyhow did not make it to the final presentation :)

[@Waragog]

This is beautiful, I've been looking at it for 5 hours already.

[@LeilaGharani]

5 hours! That's true dedication.

[@georgedebeer2315]

Leila - that was a brilliant tutorial - thanks so much!!

[@LeilaGharani]

You're very welcome. Glad you like it.

[@naqshgarg7625]

Leila your videos are really helpful, thanks for posting and sharing your knowledge

[@LeilaGharani]

You're very welcome Naqsh. Glad you find the videos useful :)

[@danielmathivathan7391]

Very well explained and in a very logical way will find this very useful in reports thanks

[@LeilaGharani]

My pleasure Daniel. I hope it'll come in handy at work.