I'm simply trying to graph some time-scale data using a date column and 3 data columns, but Excel keeps screwing up the dates in the chart... (showing dates from year 1900-1903 instead of 2018)
All of my dates in the date column are between the 12th and 13th of November, 2018 (12/11/2018
and 13/11/2018
) as in the screenshot, and the entire date column number format is set to Custom: dd/mm/yyyy HH:mm
(why doesn't Excel have this format as a predefined format??). I have also tried simply using the Date number format as well with no luck.
The Excel chart doesn't seem to think these are dates, since in the x-axis axis options, the bounds are numeric, not dates:
The date column is actually calculated from the Unix timestamp column and converted to my timezone (+10.5hrs) using the formula:
(((A2/60)/60)/24)+DATE(1970,1,1)+TIME(10,30,0)
Edit: I've also tried to copy the date column and paste as values. No luck.
Can someone tell me how to get the dates in the chart to actually use the dates in the date column?
And let me know why there might be random dates everywhere in the first place?