I don't use Excel charts often, but this chart is becoming a real challenge. I want to create a simple stacked column chart displaying the hours worked per day based on a table with date/time data. So far this was unsuccessful and none of the examples I found online offer this feature.
X-axis are the times 00:00 to 24:00
Y-axis are the dates in one month
I included a sample table with the values of one month.
This chart is intended to display the non worked periods in a day. Thus every day, the complete time of a day (0-24) should be displayed, and the non worked hours should be empty in a column. I wonder if this is even possible, or should I first create a calculation for the non worked periods and push both non worked and worked hours in a temporary table and create the chart from there?