Overview
I have a spreadsheet with 3 columns [Name, Start time, End time] which is for scheduling purposes. I want to create a bar chart showing all of the people's availability as a series of ranges in one 24-hour period, but I'm not sure how to make it happen.
Examples
Here's the example of my data (there are more columns for the other days of the week:
I can make a basic bar chart, but it shows both times as separate bars, starting at midnight:
If I change the chart type to stacked bar, then I'm getting closer, but now there are two 24-hour periods:
And if I change the color of the start time to None, then I'm even closer, but it still won't overlap the data in a single 24-hour period:
(Stacked bar chart, transparent series)
Question
It seems I need to make it somehow overlap the data to show the ranges all in one 24-hour period.
How can I get the kind of chart I'm seeking?
EDIT: How can I get the kind of chart I'm seeking using only the existing input data?