Simple Excel Dynamic Map Chart with Drop-down

...and conditionally formats the largest value on the chart

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, which means 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 transforms 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 attention to certain categories, i.e. how to conditionally format the largest data point in the chart in a different color than the rest.

Watch the steps in this video:

Feel free to Download the Workbook HERE.

Free Excel Download

The new Excel Dashboards course is here!

Now available on Udemy

Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.

Free Ebook


  1. Wes Wilcox January 31, 2018 at 11:29 pm - Reply


  2. Grevall February 15, 2018 at 5:29 pm - Reply


Leave A Comment

Share This