Excel 2010 graphing dates and times - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit
Expired

Excel 2010 graphing dates and times

£0.00 @
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… Read More
Alllfff Avatar
8m, 3w agoPosted 8 months, 3 weeks ago
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
Alllfff Avatar
8m, 3w agoPosted 8 months, 3 weeks ago
Options

All Responses

(0) Jump to unreadPost an answer
Responses/page:

No responses yet.

Be the first, enter your answer below.

Post an Answer

You don't need an account to leave a response. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!