Here is an example of a stacked line chart generated by a MySQL query on a live database and Chart.js.
Hover your mouse over the chart to reveal extra data.
The top chart shows data for three selected staff, whereas the bottom chart shows data for all staff.
Please select a chart type and date range: