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

Learn how to create dynamic, interactive map charts in Excel, showcasing key performance indicators (KPIs) by geography. Ideal for visualizing company, division, or product performance across different regions.

✨ Key Highlights:
▪️ Interactive Map Creation: Step-by-step guide to building a dynamic map that lets you switch views between divisions and see the revenue for each region.
▪️ Techniques & Tools: Discover how to use scatterplots with background images, transition to bubble charts, and add extra dimensions to your charts.
▪️ Data Visualization: Enhance your maps with interactivity, allowing users to select divisions and visualize revenue changes.
▪️ Practical Example: Watch us create a sample map chart, showing revenue data for different regions and divisions.
▪️ Advanced Tips: Learn conditional formatting in charts to highlight key data points, like the region with maximum sales.

00:00 How to Create Interactive Map Charts in Excel
03:03 Adding Map Picture
06:12 Data Preparation
07:40 Setting Up the Chart
09:29 Adding Interactivity to the Chart
12:08 Updating the Bubble Chart
15:03 Conditionally Format Data Points

The technique shown uses a scatter plot first to set up the respective points on the map and then turns it into a bubble chart to be able to visualize the actual KPI.

I also show you how you can conditionally format specific data points to bring the attention to certain categories. In this case I conditionally format the largest data point in the chart in a different color than the rest. This technique is really simple but has a very powerful effect. It makes the difference between a "nice" Excel dashboard to a "great" Excel dashboard. All it takes is 3 minutes of your time.

Links to related videos:

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

[LobanRahman]

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

[patrikw]

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

[jebat]

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! 👍 👍 👍

[mytungkai]

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

[surfmarko]

Where have you been all my life? THANK YOU!

[aesop]

you are such a genius never seen anything this awesome

[patricksoo]

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

[bsf]

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

[thomasweber]

Great video. Really like how you explain this stuff. Very helpful, looking forward to watching more videos

[saichand]

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..

[orelreshka]

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

[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.

[skylucrew]

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..

[Gymgeek]

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!

[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.

[TS-yyjb]

You are an excel hero. Of all the channels on YouTube 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.

[rohilla]

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

[chrismo]

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!

[taffyjones]

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

[burgek]

Brought a tear to my eye - that was just brilliant!