1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Plot lat/lon points on a world map in Excel?

Discussion in 'Business Applications' started by Riverglen, Apr 16, 2010.

Thread Status:
Not open for further replies.
  1. Riverglen

    Riverglen Thread Starter

    Joined:
    Aug 28, 2006
    Messages:
    506
    First Name:
    Larry
    I am using Excel 2000, and I know that there are some rudimentary mapping capabilities, but I don't believe that they are sufficient to do what I would like to do.

    I have a spreadsheet with a lot of data that includes locations in terms of their latitude and longitude. I would like to plot these points on a world map. Anyone know of a way to do this?
     
  2. Ent

    Ent Trusted Advisor

    Joined:
    Apr 11, 2009
    Messages:
    5,467
    First Name:
    Josiah
    Please post the spreadsheet, or be a little more specific with regard its format.

    I believe what you want to do is possible by creating a Scatter chart.
    Select the Lat/Lon columns, and choose the XY scatter option. Work through and complete the wizard.
    Right click somewhere in the grey area and click Format Plot Area. Click Fill effects, then picture, and get your world map.

    At present I can forsee two difficulties in this approach. The map has to be stretched out into a rectangle rather than given as a globe or it won't work. And converting longitude and latitude values into numbers that can be plotted could be a problem. Even so I don't doubt that we can work these out if you want to.
     
  3. Riverglen

    Riverglen Thread Starter

    Joined:
    Aug 28, 2006
    Messages:
    506
    First Name:
    Larry
    Thanks for the suggestion. I agree that it would probably work, assuming that the map is in cartesian coordinates and the the origin of the plot is set to 0 degrees lat, 0 degrees lon. I may give this a try if I can find a suitable image file of a map to use a background.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/917391

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice