Groups
    EXPIRED

    Excel 2010 graphing dates and times

    Hello, I have a table of tides, sun rises/sets, and moon phases, I would like to plot it all against each other but im having difficulty using date and time on the X-Axis...

    Dates are in mm/dd/yyyy format and times are hh:mm:ss

    Sun value 7 (y-axis) represents sunrise, -1 (y-axis) sunset

    Moon value -2 (y-axis) new moon, 8 (y-axis) full moon, 5 (y-axis) first/last quarter

    Example date is as such

    tides sun moon

    01/01/2016 00:05:00 1.52 01/01/2016 08:45:00 7 01/02/2016 5

    01/01/2016 07:12:00 4.84 01/01/2016 15:49:00 -1 01/10/2016 -2

    01/01/2016 12:21:00 2.05 01/02/2016 08:44:00 7 01/16/2016 5

    01/01/2016 19:22:00 4.98 01/02/2016 15:50:00 -1 01/24/2016 8

    01/02/2016 00:59:00 1.83 01/03/2016 08:44:00 7 02/01/2016 5

    01/02/2016 08:02:00 4.66 01/03/2016 15:51:00 -1 02/08/2016 -2

    01/02/2016 13:16:00 2.3 01/04/2016 08:44:00 7 02/15/2016 5

    01/02/2016 20:14:00 4.79 01/04/2016 15:53:00 -1 02/22/2016 8

    01/03/2016 02:02:00 2.06 01/05/2016 08:43:00 7 03/01/2016 5

    01/03/2016 08:56:00 4.57 01/05/2016 15:54:00 -1 03/09/2016 -2

    01/03/2016 14:28:00 2.45 01/06/2016 08:43:00 7 03/15/2016 5

    01/03/2016 21:11:00 4.68 01/06/2016 15:56:00 -1 03/23/2016 8

    01/04/2016 03:21:00 2.16 01/07/2016 08:42:00 7 03/31/2016 5

    01/04/2016 09:53:00 4.58 01/07/2016 15:57:00 -1 04/07/2016 -2

    01/04/2016 15:57:00 2.41 01/08/2016 08:42:00 7 04/14/2016 5

    01/04/2016 22:10:00 4.67 01/08/2016 15:58:00 -1 04/22/2016 8

    01/05/2016 04:37:00 2.07 01/09/2016 08:41:00 7 04/30/2016 5

    01/05/2016 10:50:00 4.69 01/09/2016 16:00:00 -1 05/06/2016 -2

    01/05/2016 17:07:00 2.19 01/10/2016 08:40:00 7 05/13/2016 5

    01/05/2016 23:09:00 4.78 01/10/2016 16:02:00 -1 05/21/2016 8

    01/06/2016 05:33:00 1.88 01/11/2016 08:39:00 7 05/29/2016 5

    Thank you very much for your help

    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. Win a Free minion usb stick77
      2. Tv choice magazine Issue 391313
      3. Magazine competitions - Issue 38 @ tvchoicemagazine.co.uk1717
      4. totalev.com comp - win an electric car2020

      See more discussions