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…