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