Community Version 9.2.1
macOS Sequoia 15.7.3
I have two sets of data collected at hourly intervals, 22:00, 23:00, … 07:00 so 3 columns. The first column is the time the data was taken, the next 2 columns are temperatures.
I have inserted an XY chart. The category axis doesn’t regard the categories as times, even though they are formated at times.
Instead, it regards them as numbers and sorts numerically, 00:00, 1:00, 2:00 … 22:00, 23:00 as in the uploaded chart.
A problem I have already seem reported, it is not possible to set intervals on either axes so I can’t set hourly categories but OnlyOffice calculates some arbitery interval.