show geographic locations on excel sheet

[sebyjohn73]

I need to maintain an excel sheet showing the current position of some
items I rent out to different parts of the country. For easier
understanding of my colleagues, I would like to have the country map on
my sheet, with the position of the items indicating presence or absence
when I enter the required values in another shhet in the same workbook.
Can someone help me to find a way to do this

Regards, Seby John

 

[JLatham]

Have you investigated this:
http://support.microsoft.com/default.aspx/kb/147637

 

[EricG]

XL2002 and beyond no longer have the map object built in. Instead, Microsoft
wants you to use an external mapping program (such as Mappoint) to do it, as
discussed in the article below.

HTH,

Eric

http://office.microsoft.com/en-us/excel/HA010346591033.aspx

 

[JLatham]

Thanks for posting the right link! I grabbed the wrong darned one. Although
maybe someone else might need it if they've kept an older version of Excel on
their system all this time.

 

[EricG]

Glad to help.

Thanks for posting the right link! I grabbed the wrong darned one. Although
maybe someone else might need it if they've kept an older version of Excel on
their system all this time.

 

[EricG]

Here is one more source of ideas for mapping your data without having to
purchase Mappoint.

http://en.allexperts.com/q/Excel-1059/Graphing-Geographical-data-Maps.htm

 

[sebyjohn73]

Thanks all, for your suggestions. I'm working out on your ideas, and so
far it's going well.

Regards, Seby