New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Creating map in excel

Macros, VBA, Excel Automation, etc.

Creating map in excel

Postby alhindi » Mon Jan 23, 2012 3:21 am

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.
  • 0

alhindi
Rookie
 
Posts: 1
Joined: Jan 23, 2012
Reputation: 0

Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot] and 118 guests

cron