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

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



"sebyjohn73" wrote:


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




--
sebyjohn73

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/ex...346591033.aspx


"sebyjohn73" wrote:


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




--
sebyjohn73

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" wrote:

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/ex...346591033.aspx


"sebyjohn73" wrote:


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




--
sebyjohn73

Glad to help.

"JLatham" wrote:

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" wrote:

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/ex...346591033.aspx


"sebyjohn73" wrote:


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




--
sebyjohn73

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

http://en.allexperts.com/q/Excel-105...-data-Maps.htm


"sebyjohn73" wrote:


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




--
sebyjohn73

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

Regards, Seby