Hi
Looking to create a stacked chart from the following data, with 5 columns for each region (Latam, Asia etc), which each column showing the contribution from each country. Thanks in advance!
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Looking to create a stacked chart from the following data, with 5 columns for each region (Latam, Asia etc), which each column showing the contribution from each country. Thanks in advance!
| COUNTRY | REGION | WGTD SPRD | |
| CN | CHINA | ASIA | 8.509785768 |
| CL | CHILE | LATAM | 4.373079539 |
| PL | POLAND | EUROPE | 1.558244222 |
| TN | TUNISIE | MENA | 1.062855315 |
| MY | MALAYSIA | ASIA | 3.882215396 |
| BR | BRAZIL | LATAM | 8.681842411 |
| CO | COLOMBIA | LATAM | 6.305857717 |
| MX | MEXICO | LATAM | 17.10351413 |
| PA | PANAMA | LATAM | 4.439593717 |
| PE | PERU | LATAM | 4.655191999 |
| UY | URUGUAY | LATAM | 4.976473036 |
| BG | BULGARIA | EUROPE | 0 |
| HR | CROATIA | EUROPE | 2.074347758 |
| SK | SLOVAKIA | EUROPE | 0.078217528 |
| RO | ROMANIA | EUROPE | 2.908111714 |
| HU | HUNGARY | EUROPE | 3.943403829 |
| SI | SLOVENIA | EUROPE | 0 |
| LT | LITHUANIA | EUROPE | 0.442214425 |
| LV | LATVIA | EUROPE | 0.012464232 |
| IL | ISRAEL | MENA | 0 |
| ZA | SOUTH AFRICA | AFRICA | 9.78567229 |
| RU | RUSSIA | EUROPE | 8.520739027 |
| TR | TURKEY | EUROPE | 15.95523245 |
| PH | PHILIPPINES | ASIA | 3.64328531 |
| VN | VIETNAM | ASIA | 0.572362147 |
| ID | INDONESIA | ASIA | 9.398259373 |
| SV | EL SALVADOR | LATAM | 5.785032535 |
| DO | DOMINICAN REPUBLIC | LATAM | 9.681428833 |
| TT | TRINIDAD & TOBAGO | LATAM | 1.082453618 |
| BO | BOLIVIA | LATAM | 1.254268062 |
| PY | PARAGUAY | LATAM | 1.684446638 |
| CR | COSTARICA | LATAM | 4.748889197 |
| GT | GUATEMALA | LATAM | 1.247882094 |
| JM | JAMAICA | LATAM | 3.414150387 |
| LB | LEBANON | MENA | 17.99515142 |
| SA | SAUDI ARABIA | MENA | 0 |
| QA | QATAR | MENA | 0 |
| AE | UAE | MENA | 0 |
| BH | BAHRAIN | MENA | 0 |
| KW | KUWAIT | MENA | 0 |
| EG | EGYPT | MENA | 13.61184543 |
| JO | JORDAN | MENA | 2.505496313 |
| IQ | IRAQ | MENA | 3.375336922 |
| OM | OMAN | MENA | 10.00388116 |
| KZ | KAZAKISTAN | EUROPE | 6.964425286 |
| AZ | AZERBAIJAN | EUROPE | 3.403890925 |
| AM | ARMENIA | EUROPE | 0.63155899 |
| MN | MONGOLIA | ASIA | 2.898213295 |
| RS | SERBIA | EUROPE | 1.031119629 |
| LK | SRI LANKA | ASIA | 10.63158526 |
| IN | INDIA | ASIA | 1.523123534 |
| NG | NIGERIA | AFRICA | 8.502772682 |
| MA | MOROCCO | MENA | 1.125314906 |
| AO | ANGOLA | AFRICA | 4.278153588 |
| MZ | MOZAMBIQUE | AFRICA | 1.369542064 |
| SN | SENEGAL | AFRICA | 2.192125565 |
| NA | NAMIBIA | AFRICA | 0.925258792 |
| TJ | TAJIKISTAN | EUROPE | 0.558202758 |
| ET | ETHIOPIA | AFRICA | 0.916408632 |
| CM | CAMEROON | AFRICA | 0.933407637 |
| KE | KENYA | AFRICA | 4.309246286 |
| GH | GHANA | AFRICA | 4.611478312 |
| GA | GABON | AFRICA | 2.55666544 |
| ZM | ZAMBIA | AFRICA | 5.137035945 |
| AR | ARGENTINA | LATAM | 20.55479979 |
| VE | VENEZUELA | LATAM | 56.73653495 |
| EC | ECUADOR | LATAM | 18.98317083 |
| HN | HONDURAS | LATAM | 1.161622798 |
| SR | SURINAME | LATAM | 0.709900775 |
| BZ | BELIZE | LATAM | 0.484300318 |
| CI | IVORY COAST | AFRICA | 3.954714253 |
| BY | BELARUS | EUROPE | 1.699018382 |
| GE | GEORGIA | EUROPE | 0.588808351 |
| UA | UKRAINE | EUROPE | 18.62795063 |
| PG | PAPUA NEW GUINEA | ASIA | 0.534330177 |
| PK | PAKISTAN | ASIA | 5.892622969 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
