Results 1 to 2 of 2

Thread: Time Series Charts

  1. #1

    Time Series Charts



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am trying to create a simple time series for culmulative tonnage, the data I have is mainly covering a couple of days and each entry is timed by hours and minutes. After many attempts the best that I can arrive at are two charts, neither of which are really correct but seem to be the best that I can do, the charts are too large to send on the forum. I enclose a portion of the data the total of which is 105 lines long. I have also reversed the order of the columns and have date and hours and minutes in the time column The first will not give me a spread across the chart and so is not able to give an overall picture. The second chart (not shown) on the right gives a better view overall but shows a timeline in the chart but a horizontal axis which simply shows the number of data points





    Time Culmulative Gross Tonnage
    07/06/2016 13:51 231
    12/06/2016 19:08 595
    13/06/2016 04:49 802
    23/06/2016 14:38 1681
    24/06/2016 13:13 1711
    24/06/2016 15:49 1792
    28/06/2016 17:58 2161
    29/06/2016 14:48 3850
    30/06/2016 06:15 5726
    30/06/2016 09:08 60191
    30/06/2016 09:43 60559
    30/06/2016 10:51 68104
    30/06/2016 10:53 85384
    30/06/2016 14:08 179195
    30/06/2016 17:34 179930
    30/06/2016 18:46 183883
    30/06/2016 20:43 184225
    01/07/2016 01:00 188178

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,568
    Articles
    0
    Excel Version
    365
    ?
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Capture3.JPG 
Views:	36 
Size:	59.1 KB 
ID:	5364  
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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