Results 1 to 2 of 2

Graph from otherwise organised data

Threaded View

  1. #1
    Registered User
    Join Date
    12-30-2013
    Location
    Holland
    MS-Off Ver
    Excel 2003
    Posts
    0

    Graph from otherwise organised data

    In the attached picture you can see the excel sheet I am working on right now, I need to make a graph of the placement of a orbiting sphere.
    On one axis there needs to be the x-placement and on the other axis the y-placement. It has to be a spread graph so you can see the placements over time.
    Problem is, as you can see in the picture, the x and the y value are beneath each other in every step, but aren't organised in a table.
    Since there are over a thousand steps in the sheet organising by hand isn't an option. Is there any way of systematically arranging this data if the distance between the x-values and the y-values between different steps is constant?
    Thanks in advance, if you're not feeling like posting an entire tutorial you could also give some keywords so I can look it up myself.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 9
    Last Post: 05-28-2014, 03:27 AM
  2. [SOLVED] Sorting a spreadsheet of data that is consistantly disorganised into organised columns
    By stewart@itsit.com.au in forum Excel General
    Replies: 8
    Last Post: 10-10-2012, 10:40 AM
  3. Replies: 3
    Last Post: 08-21-2012, 07:28 PM
  4. Conditional concatenation problem for badly organised data
    By XL4NEthing in forum Excel General
    Replies: 2
    Last Post: 02-02-2012, 12:25 PM
  5. [SOLVED] How do I update my static line graph to allow a user to select which data to graph
    By capcon in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-31-2011, 10:22 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