Hi friends,
I have a task given by my manager....
he wants to have a map show the diversity of the nationalities we have in the company.
but the data should mark at the correct country on the map and be updated everytime we update the excel sheet.
for example i have the following data in excel
india pakistan egypt sri lanka britain nepal america
mep 5 3 5 10 5 4 1
cleaners 15 2 1 15 4 6 0
security 2 1 7 2 7 8 0
total 24 6 13 27 16 18 1
i want the total to be displayed on the world map and on the specific country.
any idea how i can do that? and it should be updated everytime he updates the spreadsheet.
i thought of making links of single cells on the powerpoint slide with the world map on the background.
is it possible?
thanks in advance.