How to create a dynamic map chart with drop-down (works with ANY Excel version)

About this tutorial:

Video duration: 17:34
Create a simple but effective Excel Dynamic Map Chart with drop-down. Also Conditionally formats the largest values on the map for improved readability.

Learn how to create a simple but impressive dynamic map chart that enables you to visualize specific KPI’s by geography. This method doesn’t use the relatively new Bing map feature, so it is works on all Excel versions.

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…

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

27 thoughts on “How to create a dynamic map chart with drop-down (works with ANY Excel version)


    (October 23, 2019 - 8:42 am)

    Hello Leila, there is a big gap in my revenue number. which causes my bubble size to become bearable when I decrease the size of the bubble. How can I make all the bubble size equal without changing my revenue numbers.

    Thamer AL-QERSHI

    (October 23, 2019 - 8:42 am)

    You are the best. Thank you so much


    (October 23, 2019 - 8:42 am)

    Is there any way i can Add GIF on google my map any one can help me please i will appriciate

    Ross Clark Zilchlight64

    (October 23, 2019 - 8:42 am)

    Hi Leila, I just watched your '"How to create a dynamic map chart with drop-down'', is it possible to show information from points on a dynamic map? eg – a map of a country with regions locations, when clicked on, they provide information of that region, preferably in excel .. ? and if there could be more that one layer of information, eg – if that region has towns, and the information of those towns is displayed when thy are clicked on.. or is what I am thinking of something completely different ? Your response would be greatly appreciated 🙂 Ross.

    taffy jones

    (October 23, 2019 - 8:42 am)

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


    (October 23, 2019 - 8:42 am)

    Hi Leila, thank you for this tutorial. Would it be possible to take it one step further to not just show size but also pie chart? e.g. Europe has a revenue breakdown of commercial and non-commercial amounts.


    (October 23, 2019 - 8:42 am)

    عالی بود 👍👍👍👍👍👍👍🙏🙏🙏🙏🙏


    (October 23, 2019 - 8:42 am)

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

    Darsh Ragab

    (October 23, 2019 - 8:42 am)

    you are brilliant

    Khyam Baig

    (October 23, 2019 - 8:42 am)

    Fantastic video. Thank you so much ☺️

    John Vodopija

    (October 23, 2019 - 8:42 am)

    I have learnt something today. Thank you for such great instruction 🙂

    Ari Lesser

    (October 23, 2019 - 8:42 am)

    Great video! Is there a way to lock the scale of bubbles between values across divisions? Example: one data set has lower numbers, and the bubbles are being depicted larger than another division which has higher numbers across.

    Rabih El-Habta

    (October 23, 2019 - 8:42 am)

    Amazing is it possible to do directional maps with excel? e.g arrows representing trade flows between country say X and countries Y1,2,…, Yn. If it is possible could you make a video? thank you so much 🙂

    Miguel Garcés

    (October 23, 2019 - 8:42 am)

    It was amazing! I am enjoying your videos so much. You are so great!

    Oguz Han

    (October 23, 2019 - 8:42 am)

    You are awesome!

    Ammar Ahmed

    (October 23, 2019 - 8:42 am)


    Please show more about not the same region.

    Marcel Aguiar

    (October 23, 2019 - 8:42 am)


    Bee S

    (October 23, 2019 - 8:42 am)

    Awesome !!! Followed that great lesson and created mine chart. Lots of thanks 🙂

    Hazem Ali

    (October 23, 2019 - 8:42 am)

    Many thanks Leila

    Sydna Amos

    (October 23, 2019 - 8:42 am)

    Very Informative

    Sudipto Guchait

    (October 23, 2019 - 8:42 am)

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

    Darian M.

    (October 23, 2019 - 8:42 am)

    Leila, I love your videos!
    Now please marry me!

    Ewan Harris

    (October 23, 2019 - 8:42 am)


    Tahir Abbas

    (October 23, 2019 - 8:42 am)

    very very useful. thank you very much Leila


    (October 23, 2019 - 8:42 am)

    I loved this tutorial! I was wondering if there was a way to add this to a PowerPoint presentation? I haven't been able to…

    Ethan C

    (October 23, 2019 - 8:42 am)

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *