I want to make a standard X-Y scatter plot with a proper date on the X-axis showing year month & day in no particular order. I do not want to make any changes to column A.
The key seems to be selecting the right format category/format code in excel. I've played around there for some time trying different localization, different custom codes but nothing worked so far. Either doesn't work at all or shows as the year 1901 or 1900.
Does someone have the complete custom definision for this specific ISO date/time format? I think then it's a 5 second fix to copy/paste that custom format in there or?
Regards
Schwizer
Timestamp | Value A | Value B |
2021-12-15T11:02:46.7483390+01:00 | 84 | 3 |
2021-12-15T11:01:47.0353530+01:00 | 85 | 4 |
2021-12-15T11:00:46.8114890+01:00 | 79 | 5 |
The key seems to be selecting the right format category/format code in excel. I've played around there for some time trying different localization, different custom codes but nothing worked so far. Either doesn't work at all or shows as the year 1901 or 1900.
Does someone have the complete custom definision for this specific ISO date/time format? I think then it's a 5 second fix to copy/paste that custom format in there or?
Regards
Schwizer