How to create a time based bar chart in LibreOffice Calc, similar to a Gantt chart?

[MaliTaus]

Hi,

I have searched high and low for a non-stacked, horizontal bar chart that shows sleep cycles (number and duration). The best way to describe what I want to do is visually - please see attached screenshots of some example base data and a mock up of the chart I want to produce. The data is all good: time format and appropriate time formulas, count the cycles, etc.

I want dates on the Y axis and hours of the day on the X axis. The chart also needs to expand downwards as I add more data.

I have read similar topics in ask.libreoffice.org such as the one below but can’t see what I want:
How to create a chart with date-time values. - #17 by Wtx_Engineer

Thanks!

Version: 7.4.7.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Debian package version: 4:7.4.7-1+deb12u8
Calc: threaded

[Lupp]

Do you know this thread in a different forum? It is a bit bloated, but contains some reasonable suggestions. There is also an as-if-solution by myself without a chart using conditional formatting for the visualisation. It’s built along a concept I once “invented” to solve a task of the original Gantt-type.
Anyway you should reconsidser the structure of your data.
Currently you start with something you consider a date, but even the first tranch only ends on the next day. The scheme would get completely confusing if your first “tranch of sleep” once starts after midnight.
Next flaw is the fix maximum number of tranches given for any specific “day”.
For a consistent solution it’s next to necessary that every tranch gets its own row as the data set. Each such row will in your case contain a date (real dates always are YYYY-MM-DD) to which the tranch shall be assigned.
In your case the visualisation should be placed then on a dedicated sheet where each row represents an “assigned date” and displays all the tranches for this date.
In any related or similar case “points in time” must be described by complete date-time-values. Real time is NOT cyclic!
… …
== Editing 2025-06-13 ==
Since no proposed solution has been accepted so far and my suggestion may seem “strange” and difficult to implement, I have made an example showing how to do it:
disask123005_SleepLogDiaWithoutExtraSheet.ods (64.0 KB)

[MaliTaus]

Thank you! I will take a longer look tomorrow as it all sounds pretty complicated.

[MaliTaus]

Thanks again for the advice. I can see how it might work with one time interval per row, but with several per row? For example, if the rail yard example had the train in the yard TWICE in a 24 hour period?

I have five or six time periods on one row (one night/morning).

Insomniac, you see… Sleep log file attached:
Sleep log_.ods (67.1 KB)

[Zizi64]

There ara some templates on the Extension sites:

Extensions » Libreoffice Extensions

.
https://extensions.openoffice.org/en/search?query=gantt
.
And there are videos on the YT:
https://www.google.hu/search?sca_esv=d249094845342318&q=libreoffice+gantt&udm=7&fbs=AIIjpHwXYzS39-WXOv-RmQI635nSAKvBRlU9xo20qUS3MBQ5rOJMIWahBTsgpHIaJWi_FQBxLGKc7xcNX_QViRhOvnsR50i4uUIafnYuQboYcowtX7gnbKfoXpyxTGIPsh3KUVeP06msqLX5kC6zcGdxkYUbBnv_uSmMJoPMREtcmLp_tOGKaUCt1RII_jn2rresJpTe-OEt&sa=X&ved=2ahUKEwjolv7Iw-iNAxUU9bsIHf5tJxIQtKgLegQIFRAB&biw=1280&bih=645&dpr=1.5

[Lupp]

@MaliTaus: I edited my comment above.

[topo_gigio]

hi, what do you think of this solution?
PROVA.ods (15.2 KB)

[fpy]

@topo_gigio

this

pretty hardcoded
question is : how much does it cost to add a new day, a new period ?

see with a lookup here : Calendrier de type perpétuel pour le travail - #2 by fpy