Hi,
Here's how you can create a stacked bar chart-
- Head to the "Insert" tab on the Excel ribbon after selecting the data range (including headers).
- From the "Charts" group, pick a stacked bar chart or a clustered bar chart.
- After inserting the chart, select "Format Axis" from the context menu by right-clicking on the vertical axis (the one that represents people).
- Change the "Axis labels" option to "Low" in the "Format Axis" pane to make the bars start on the chart's left side.
- To make sure all bars are visible, you might also want to set the axis' maximum value to the number of people you have.
- The chart should now show the beginning and end times for each individual in parallel.
Best Regards.