Hi All,
I am a fresh-man in GIS. I have just faced a problem and I am sharing it to have the best answer for its solution:
I have a map to generate and show the types of training and number of participants on the map province/state wise. I want to show each training type with a symbol i.e. square, circle, rectangle; in addition also show the total number of participants per training and per province/state. (Below, I have attached the table for better understanding)
i.e. there have been 4 types of training in Kabul province. with ASP having 486 participants, Java having 36 Participants, VB having 753 participants and C++ having 101 participants.
I would be highly appreciated, to have your views and guidance.
| Province | ASP | Java | VB | C++ |
| Badakhshan | 233 | | 362 | 35 |
| Badghis | | | 53 | |
| Baghlan | 54 | | | |
| Balkh | 125 | | 184 | 9 |
| Bamyan | 78 | | 233 | 29 |
| Daykundi | 55 | | 154 | |
| Farah | 30 | | | |
| Faryab | | | 30 | |
| Ghazni | | | 32 | |
| Ghor | 53 | | 119 | |
| Helmand | 45 | | 131 | 12 |
| Herat | 204 | | 364 | 28 |
| Jowzjan | 62 | | 203 | |
| Kabul | 486 | 36 | 753 | 101 |
| Kandahar | 40 | | 160 | |
| Kapisa | | | 210 | |
| Khost | | | 81 | |
| Kunar | 63 | 14 | 123 | |
| Kunduz | 89 | | 422 | 44 |
| Laghman | 32 | | 165 | 14 |
| Logar | 22 | | 45 | |
| Nangarhar | 159 | | 187 | 36 |
| Nimroz | | | 28 | |
| Paktia | | | 38 | |
| Paktika | 29 | | 77 | |
| Panjshir | | | 114 | |
| Parwan | | | 108 | |
| Samangan | 37 | | 78 | |
| Takhar | 101 | 14 | 57 | |
| Uruzgan | | | 134 | |
| Wardak | | | 145 | |