The current resolution only supports years/months/days, which is too coarse for my data (the date range of which is several hours during a day).
Hello, Did you try "Format Cells..." by right clicking in a cell. There are several formats at the end of the Date Category with time format.
Yes I tried. But that doesn't affect the resolution of X axis. It still shows all the hours/minutes' data in one day.
Created attachment 143229 [details] An example to reproduce the issue
Please can you attach the sample file not an image.
Created attachment 143233 [details] file prepared from my side I saw the issue by making this file. The Date/time formats are not displaied on the diagram. I got the right formating in X Axis by editing the chart(double click on the chart), right click to select the X axis and select "Format Axis..." in contextual menu, and choose Text in Scale Type. Thats all. Another way is shown on the second sheet. You ave to format your date as standard Number and next to change X axis format Number to Date and time according format. I have to verify some little thinks and I come back to confirm the bug.
Time part in Chart Date format not displaied also in LO 3.5.3.2 Version ID : 235ab8a-3802056-4a8fed3-2d66ea8-e241b80 on Windws 7 home. So probably inherited from OOo.
Created attachment 143248 [details] Time line in xy-chart You should use an XY-chart for time lines in the range of hours. The special feature of line charts, that you can get a grid line each month although the real time from month to month is different, is not needed in the scale of hours. In that scale each major interval (date) has the same minor interval (hour). The time axis for line charts does not allow shorter intervals, because then you would on one hand have equal distances between e.g. 1.Jan, 1.Feb, 1.Mar, and on the other hand have different distance of 31 days and 28 days, which contradicts.
XY-chart solved my problem. Thanks!