I have imported data from my thermostat. The first two columns are “date” and “time” in the d/m/yy and hh:mm:ss formats respectively.
Excel is brilliant and recognized that those two columns together were to be used as x-axis, and they appear combined when I probe a data point on chart.
But somehow it cannot display the right date along the x-axis. Date starts at 1/0/00 0:00 and increments way too fast. It looks like it’s not using the right formula.
FYI: Microsoft® Excel for Mac, Version 16.88 (24081116)
I tried to change the Format axis>Number>Category and >Type to all available including custom Format Code but that only affects the display, not the computed date.