Map Chart Show only regions data

[Jimmypop]

Good day

I am trying to create a map chart. I have gotten to this point so far. However... I would like to show the South Africa one with the provinces as well. However for South Africa it is only showing the first data point (51%) and not dividing into the regions. Second pic is how it should look like but also showing the other three countries

as well without showing the whole continent.

 

[Jimmypop]

Any Ideas someone?

 

[Jimmypop]

Update...

Got it working....

Put Province / District First and then Country... Then used the Data tab to format them to Geography... The Map to show only regions with data...