Time vs Date Plots Help Please
Hello,
I have a long series of data that look like this sample:
Residual ValueDateTime025/01/202419:01:36026/01/202401:45:24026/01/202407:13:15026/01/202416:33:29026/01/202420:31:30027/01/202402:09:11027/01/202407:42:02027/01/202415:09:28027/01/202420:37:51028/01/202402:36:39028/01/202410:21:07028/01/202415:03:29028/01/202421:57:21029/01/202403:19:17029/01/202411:50:38029/01/202412:13:03030/01/202401:20:39
When I try to plot the times vs dates this on a scatter excel is doing this and I can’t seem to alter it:
I would like it to display like this (borrowed from another post):
Can anyone help me with this please is it’s extremely frustrating?
Thank you in advance
Seb
Hello,I have a long series of data that look like this sample:Residual ValueDateTime025/01/202419:01:36026/01/202401:45:24026/01/202407:13:15026/01/202416:33:29026/01/202420:31:30027/01/202402:09:11027/01/202407:42:02027/01/202415:09:28027/01/202420:37:51028/01/202402:36:39028/01/202410:21:07028/01/202415:03:29028/01/202421:57:21029/01/202403:19:17029/01/202411:50:38029/01/202412:13:03030/01/202401:20:39When I try to plot the times vs dates this on a scatter excel is doing this and I can’t seem to alter it: I would like it to display like this (borrowed from another post):Can anyone help me with this please is it’s extremely frustrating?Thank you in advance Seb Read More