Dynamic map within Excel based on spreadsheet values

[Michael Shaffer]

Hi, I hope this is possible, we have a team of people working on mapping
different areas of a city. Each area they are working on is called an
AOI or area of interest. These are custom polygons drawn by hand, not
states or anything like that. The excel spreadsheet keeps track of how
much progress they have made on each AOI. I was wondering if I could put
a dynamic map in the Excel spreadsheet showing the current status of
each AOI, based on a color scheme.

I've tried Mappoint but had trouble making the custom territories, it
seemed geared mostly towards using pre-defined territories like states,
counties, etc.



Thank you,
Michael Shaffer

 

[Michael]

Hi, I hope this is possible, we have a team of people working on mapping
different areas of a city. Each area they are working on is called an
AOI or area of interest. These are custom polygons drawn by hand, not
states or anything like that. The excel spreadsheet keeps track of how
much progress they have made on each AOI. I was wondering if I could put
a dynamic map in the Excel spreadsheet showing the current status of
each AOI, based on a color scheme.

I've tried Mappoint but had trouble making the custom territories, it
seemed geared mostly towards using pre-defined territories like states,
counties, etc.

Thank you,
Michael Shaffer

Ok, I found a tutorial that tells how to do this. All you do is import
the shapefiles as .emf files.

 

[ShaneDevenshire]

Hi,

Just an FYI, I believe Microsoft pulled Mappoint from later versions of Excel.

 

[Gord Dibben]

Shane

I believe OP is referring to MS MapPoint, a standalone application which can
interface with Excel.

You may be thinking of the old MS Map which was installed with Office prior
to Office 2002.


Gord