This is because of your data structure. You need to prepare data in a way that there is only one column with countries
Without any other data rearrangement, you can have two columns showing your geolocation through dual axis.
1.Holding Ctrl, Drag and Drop Longitude next to each other.
2. Make it Dual Axis
3. Change one of them to show Sub Country 2
I would recommend data restructuring, were you to get all countries in view.
Ahh okay. Thank you so much, you've been really helpful!