Help with excel map chart formatting

[ghost_ng]

I have a worksheet that looks like the below. I want to be able to use excel map charts to display the world map (each country) and when highlighted or clicked, the country will tell me what organization (WTC, BRICS, etc) it is a part of. I assume i have to reformat my source data, but I cant figure out the best way to. Please help! TIA.

Country	WTO	BRICS	ASEAN	BRI	Neodymium	Dysprosium
Afghanistan	YES	NO	NO	YES	NO	NO
Albania	YES	NO	NO	NO	NO	NO
Algeria	NO	NO	NO	YES	NO	NO
Andorra	NO	NO	NO	NO	NO	NO
Angola	YES	NO	NO	YES	NO	NO
Antigua and Barbuda	YES	NO	NO	YES	NO	NO
Argentina	YES	YES	NO	YES	NO	NO
Armenia	YES	NO	NO	YES	NO	NO
Australia	YES	NO	NO	NO	YES	YES
Austria	YES	NO	NO	NO	NO	NO
Azerbaijan	NO	NO	NO	YES	NO	NO
Bahamas	NO	NO	NO	YES	NO	NO
Bahrain	YES	NO	NO	YES	NO	NO
Bangladesh	YES	NO	NO	YES	NO	NO
Barbados	YES	NO	NO	YES	NO	NO
Belarus	NO	NO	NO	NO	NO	NO
Belgium	YES	NO	NO	NO	NO	NO
Belize	YES	NO	NO	YES	NO	NO
Benin	YES	NO	NO	YES	NO	NO
Bhutan	NO	NO	NO	YES	NO	NO
Bolivia	YES	NO	NO	YES	NO	NO
Bosnia and Herzegovina	NO	NO	NO	NO	NO	NO
Botswana	YES	NO	NO	YES	NO	NO
Brazil	YES	YES	NO	YES	NO	NO
Brunei	YES	NO	YES	YES	NO	NO
Bulgaria	YES	NO	NO	NO	NO	NO
Burkina Faso	YES	NO	NO	YES	NO	NO
Burundi	YES	NO	NO	YES	NO	YES
Côte d'Ivoire	YES	NO	NO	YES	NO	NO
Cabo Verde	NO	NO	NO	NO	NO	NO
Cambodia	YES	NO	YES	YES	NO	NO
Cameroon	YES	NO	NO	YES	NO	NO
Canada	YES	NO	NO	NO	NO	NO
Central African Republic	YES	NO	NO	YES	NO	NO

 

[ghost_ng]

I forgot to mention I would also like the countries to be shaded based on how many orgs they are part of. 5 orgs = red, 4 orgs = green, etc etc