Hello,

This might be a simple solution for Excel gurus, but alas that is not a name that can be applied to me.

I haven't been able to find a solution (manually or online), so thought I'd post a question here.

I'd like to create a column chart to show what activites have been carried out over a period of 24 hours.

i.e.
Activity | Start Time | Finish Time
Sleep 00:00 07:00
Awake 07:00 08:00
Eat 08:00 08:30
Travel 08:30 09:00
Work 09:00 17:00
Travel 17:00 17:30
Exercise 17:30 18:30
Eat 18:30 19:00
Awake 19:00 21:00
Sleep 21:00 24:00

I'd love to display the info horizontally in a stacked column chart, where the 24 hour period would go on the x-axis and the 7 days of the week would be on the y-axis. The data itself would distinguishable through colour/legend/labels.

I thought I'd need to calculate duration of each activity, which in theory may work, but have no idea how to tweak the graph settings so it will display it the correct way (i.e. the blooming clock times).

Thank you for reading/responding.

Regards,
Sam.