Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

Drawing Lines with MapPoint from Coordinates in Excel

This is a discussion on Drawing Lines with MapPoint from Coordinates in Excel within the MapForums Plus Downloads forums, part of the MapForums Plus category; Here's a fun little Excel app that draws lines from pairs of lat/lon coordinates in Excel. I'm sure you could ...

  1. #1
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Drawing Lines with MapPoint from Coordinates in Excel

    Here's a fun little Excel app that draws lines from pairs of lat/lon coordinates in Excel. I'm sure you could come up with some interesting-looking maps

    Originally I had thought to do an app with a single starting point and then lots of ending points so there is a single "spider" graphic, but thought it would be more flexible if there are pairs of lat/lon's on the whole list, see attached.

    Also, rather than a single settings for the line Weight, Color, and Arrow, the settings are made for each individual row making it more flexible. Of course if you only have a single starting point and only want one color/weight/etc. there is a lot of redundancy on the list, but it is really easy in Excel to double-click and automatically copy that data down the whole list.

    Note that this app using lat/lon pairs, not addresses or location names, but it could easily be adjusted to use addresses or pushpin names, or whatever.

    Note that this macro attaches to an existing open instance of MapPoint. YOU NEED TO OPEN MAPPOINT FIRST BEFORE RUNNING THE MACRO. (bold just to make sure people notice this part of the instructions this long into the text haha).

    Let me know if you have any questions or would like to see this modified or integrated with your business processes

    Eric

    ____
    more info added 10/25/11

    I added a screenshot of the input form. The Colors tab is included so you can see the values of all the MapPoint color codes for easy reference.

    One obvious enhancement related to the comment above: this could be easily modified so that the Colors tab just had a list of all the valid MapPoint colors (e.g. Black, Brown, OliveGreen, DarkGreen, DarkTeal, DarkBlue, Indigo, Gray80, DarkRed, Orange) and the macro would do the translation to color code internally so the user doesn't have to deal with numeric codes Let me know if someone wants this.

    Any other suggestions welcome!

    Eric
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Eric Frost; 10-25-2011 at 11:06 AM.
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Drawing Lines with MapPoint from Coordinates in Excel

    Here's another screenshot and the Excel spreadsheet with the data and macro used to generate the lines.

    Eric
    Attached Images Attached Images
    Attached Files Attached Files
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Drawing Lines with MapPoint from Coordinates in Excel

    There is now another version of this tool using City/State pairs instead of lat/lon coordinates. It is here --

    Drawing Lines Between City/State Pairs

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Exporting Zip Codes to Excel by drawing your area?
    By Steve J in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 11-16-2008, 02:43 PM
  2. Drawing lines on the map between connected points
    By dave murphy in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 04-14-2005, 07:37 AM
  3. drawing lines on top of MapPoint control
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-29-2004, 02:23 PM
  4. Drawing contour lines from nodes in a string file
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-29-2003, 09:30 AM
  5. Is there a way to input lines (ideally from Excel ....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-01-2002, 07:21 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28