Stacked barchart with times

asked 2020-02-14 18:45:13 +0200

DaPawa gravatar image

Hi! I want to turn some data into a stacked barchart, the data is details about activities done each day with a start and end time, and I want the barchart to have 1 bar per day, with the length of activities done for each segment. My test data currently looks like:

date        activity            sub         start       end
14/02/20    programming         writing     17:00:00    18:00:00
14/02/20    research            rockets     18:00:00    19:00:00
14/02/20    programming         writing     19:00:00    20:00:00

and comes out as image description

My intended chart should look like: image description

I would be very grateful for any help!

edit retag flag offensive close merge delete


@DaPawa, Stacked columns chart may not be the preferred choice to graph a daily routine; especially if "research", "entertainment" and "programming" have a different order on different days. Perhaps assigning different background cells colors could make the trick, leaving every other column empty.

LeroyG gravatar imageLeroyG ( 2020-08-05 22:14:57 +0200 )edit