If it can be done in a grid chart, great. The part that I'm having trouble with is calculating the y axis bubble position. I would like all my bubbles spaced out and centered--and not overlapping.
Attached is an example with what I have so far (top graph), and what I want (bottom graph). Note: the bottom graph uses a cheat that I hardcoded into the script. I can't use the script to calculate because I want it to recalculate based on current filters.
Attached is the file. I want the real graph to look like the bottom graph. The y axis is basically a count of the maximum number of countries in the group, with each country getting a unique number within the group. This way I can space out my bubbles so they never overlap.