graphing vector distances from a gps position in Excel

Posted on 2011-04-28
Last Modified: 2012-06-27
I have an excel document with a center point and different distances in different directions from this center point.  Anyone have an idea on how to graph this in Excel (showing the final points of the "distances" - showing each degree)

thanks in advance Excel-Angle-Fix-WORKS-.xlsx
Question by:SullivanEnvironmental
    1 Comment
    LVL 22

    Accepted Solution

    I don't understand the structure of your sheet. But if you can calculate the 'normal' x and y coordinates for you point you can use a Macro to draw the lines as you want them. See the sheet Draw in the sample file. If you run the macro DrawLines the lines are drawn on the sheet.

    But since they seem to be GPS coordinates wouldn't it be nicer to draw them on a Binq/Google/Yahoo map.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    This article seeks to propel the full implementation of geothermal power plants in Mexico as a renewable energy source.
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now