Top |
Post New Question |
Read All |
MP2K Asks Microsoft
396
Brian Perch
-
September 14, 2001
This is simular to Julie's question. Let's say I have a territory number, zip code, and dollar amount in an excel file. Is it possible to display the Dollar amount for each zip code on the map?
Answer:
I assume your territories are made up of multiple ZIP codes, and that you want to create a thematic shaded map showing dollar amounts aggregated by territory, with an overlay showing actual values by ZIP code.
If this is the case, the answer is that you can bring in your data set of territories, ZIP codes and dollar amounts a first time to create the territory shaded map. Then, you bring the same data in a second time to create a pushpin map by ZIP code. Once you switch on the text balloons, you have numbers for each ZIP code displayed on the map.
Post New Answer / Follow-up