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 |