2-D Stacked bar chart

Excel can do this. One possible way to automate the copying of the data in the top tables into the chart table might look like (starting from my file in post #8):

1) In row 39, replace the 1st task, etc. with 1 in C39:I39, 2 in J39:P39, and so on.
2) Replace Aduration, etc. in row 40 with simple A, B, C,...
3) Build a formula in C41 that will a) test if the task in A3 matches the task in C40 then, b) if it matches, return the value from D3, else c) return 0. In a spreadsheet, this kind of decision is performed by an IF() function (https://support.microsoft.com/en-us/...c-aa8bbff73be2 ).
3a) Use an INDEX() function (https://support.microsoft.com/en-us/...2-b56b061328bd ) to access the value in the first cell of A3:A7. INDEX($A$3:$A$7,C$39) [note the mix of relative and absolute references for easy copying]. Compare to the value in C40 -- INDEX(...)=C$40. Use that as the test condition in the IF() function =IF(INDEX(...)=C$40,...)
3b) If true, then we want to use and INDEX() function to return the value from D3, if not, return 0 =IF(INDEX(...)=C$40,INDEX($D$3:$D$7,C$39),0)
4) Enter that function in C41. Then copy C41 and paste/fill into C41:AL41.
5) Repeat step 4 in C42, C43, C44, replacing the references for person 1 with appropriate references for person 2, person 3, person 4.

Now, you can enter your values in the tables at the top of the sheet, and those entries/edits should be reflected in the chart table and in the chart.