Time Series Charts

ClareF

New member
Joined
Jul 14, 2016
Messages
1
Reaction score
0
Points
0
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





TimeCulmulative Gross Tonnage
07/06/2016 13:51231
12/06/2016 19:08595
13/06/2016 04:49802
23/06/2016 14:381681
24/06/2016 13:131711
24/06/2016 15:491792
28/06/2016 17:582161
29/06/2016 14:483850
30/06/2016 06:155726
30/06/2016 09:0860191
30/06/2016 09:4360559
30/06/2016 10:5168104
30/06/2016 10:5385384
30/06/2016 14:08179195
30/06/2016 17:34179930
30/06/2016 18:46183883
30/06/2016 20:43184225
01/07/2016 01:00188178
 
?
attachment.php
 

Attachments

  • excelGuru6384.xlsx
    12.1 KB · Views: 20
  • Capture3.JPG
    Capture3.JPG
    59.1 KB · Views: 43
Back
Top