I would start with the "clustered and stacked" column charts. I observe that this tutorial is mostly about how the data are arranged in the spreadsheet. Once the data are arranged properly in the spreadsheet, the chart is relatively easy to create.

From there, the line part should be a relatively simple combination chart with the stacked column chart. Easiest will be a line-stacked column combination chart, but you may want a scatter-stacked column combination chart if you feel a need to change the left/right position of the line chart data points on top of the stacked column chart.