How do I display data in a map

K

KJ

I want to link data in a spreadsheet to a map of the US. I am using Excel
2003. Is there any way to do this?
 
M

medicenpringles

i'm not sure of any specific places, but using Excel's External Data
function, it shouldn't be too hard. what exactly are you looking for?
 
J

Jon Peltier

In earlier versions of Office, at least in 97 and 2000, there was a little utility
that inserted a map you could use for this. If one of these still exists on your
computer, you can probably access the map from the Insert - Object dialog (I can in
Excel XP). If you still have the installation CDs from an earlier Office version,
you may be able to get back that utility.

Barring this, you need to purchase Microsoft MapPoint or investigate third party
options.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
I have resources in a table and I want to show allocation by US state.

:
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to map SharePoint drives permanently 0
Merging from an Excel file with graphics 1
How to automate update on weekly reports spreadsheet 0
Chart Data to a US map 1
Linking data in MS Word into Excel 5
Excel map available in office 2007? 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Creating a Chart on form from selected data in query. 0

Top