+ Reply to Thread
Results 1 to 4 of 4

XYZ scatter or similar required to plot route through 105 points in 3 dimensions

  1. #1
    Registered User
    Join Date
    05-29-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003/2010
    Posts
    3

    XYZ scatter or similar required to plot route through 105 points in 3 dimensions

    Ok so this probably a bit weird but I am playing a space trading game called Elite: Dangerous, this game has a realistic map of the Milky Way galaxy (all 400 billion stars).

    Of all these stars there are 105 that I want to visit in a loop so I want to plot the best route to do this. I have the X,Y,Z coordinates for each system and have created a 2D scatter chart from the X,Y values which I was able to label the points with a plugin I downloaded, but the extensive range of Z values makes this void.

    I also found a plugin for a 3D scatter graph but it's hard to view in 2D.

    I realise Excel is probably not the best program for this, but is there a way to create a rotatable, 3D scatter graph where the points can be individually labelled that doesn't cost thousands of dollars?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,835

    Re: XYZ scatter or similar required to plot route through 105 points in 3 dimensions

    Have you tried Andy Pope's 3D xy scatter spreadsheet: http://andypope.info/charts/3drotate.htm
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: XYZ scatter or similar required to plot route through 105 points in 3 dimensions

    Looks like the same question as this one here

    http://www.excelforum.com/excel-gene...ordinates.html

    You'll find a few solutions in the attached link
    Happy with my advice? Click on the * reputation button below

  4. #4
    Registered User
    Join Date
    05-29-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003/2010
    Posts
    3

    Re: XYZ scatter or similar required to plot route through 105 points in 3 dimensions

    It's exactly the same issue LOL thank you - didn't think anyone else here would have asked that question.

    Hopefully I will find my answer there.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Identifying Points in a Scatter Plot
    By jbianco51 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-20-2014, 04:42 PM
  2. scatter plot with 2 extra dimensions time and location --- HELP!
    By dbrowndo in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-04-2013, 02:05 PM
  3. Representing same data points in a scatter plot
    By Chandelia in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-03-2009, 05:54 AM
  4. Only plot scatter points that have both an X and a Y value (2007)
    By JayUSA in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-15-2009, 04:23 AM
  5. [SOLVED] Scatter plot points x and y coordinates
    By Milo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-28-2005, 07:25 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1