Stacked Bar Chart

[pdhil87]

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

 

[Gerald Higgins]

OK, go right ahead. If you have any problems with any part of it, post back with details of what exactly you're struggling with, and maybe someone here can help.