+ Reply to Thread
Results 1 to 7 of 7

How to make a graph from data consisting of 1000 lines in a .txt file?

  1. #1
    Registered User
    Join Date
    04-12-2011
    Location
    Iowa
    MS-Off Ver
    Excel 2003
    Posts
    4

    How to make a graph from data consisting of 1000 lines in a .txt file?

    hello,

    I have a .txt file with 1000 lines of data. This data was collected from an electronic compass located in a car moving in different directions.
    Each line was written in function of time,every 0.1s.
    Each line has 4 columns, and each column represents a cardinal point.
    1st column--->North, 2nd column--->East, 3rd Column South---> 4th column West
    768------768------768------2
    768------768------768------2…
    768---------2------768---768…
    768---------2------768---768…
    768---------2-------2-----768
    768---------2-------2-----768…

    When there is a low number, it means that the compas is moving in that direction.
    So, the first two lines, it is moving westwards, the next two lines is moving eastwards and the last two ones south-eastwards.

    How can I graph the trajectory of the car?
    Or at least how can I manage to make a graph with this data?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: How to make a graph from data consisting of 1000 lines in a .txt file?

    You just need to determine the x and or y increment for each reading.

    I have altered your example route to more clearly illustrate the path in the chart.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-12-2011
    Location
    Iowa
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: How to make a graph from data consisting of 1000 lines in a .txt file?

    Thanks. Very useful.

    I have more than 1000 lines to convert the "768" and "2" to 0 and 1 for each x, y.

    Is there a way to have Excel do the process automatically?

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: How to make a graph from data consisting of 1000 lines in a .txt file?

    those 1 an 0s are done with formula. you just need to drag down to cover your data rows

  5. #5
    Registered User
    Join Date
    04-12-2011
    Location
    Iowa
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: How to make a graph from data consisting of 1000 lines in a .txt file?

    I would like, as you say, to drag down to cover the data rows and to have the 768 and the 2 converted to 0 and 1.
    And then to sort out this 0 and 1 into this eight cols.,Xnorth,Xeast,Xsouth,Xwest,Ynorth,Yeast,Ysouth,Ywest., for every row..

    What formula can I use to do that?

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: How to make a graph from data consisting of 1000 lines in a .txt file?

    you don't do it with formula you do it manually.

  7. #7
    Registered User
    Join Date
    04-12-2011
    Location
    Iowa
    MS-Off Ver
    Excel 2003
    Posts
    4

    Smile Re: How to make a graph from data consisting of 1000 lines in a .txt file?

    I will,lol.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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