 | |
| How to create a dynamic map chart with drop-down (works with ANY Excel version) |
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 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.
Related Topics:
Post a Comment