Creating a chart in Excel with start time and duration

Question

I want to create what is essentially a Gantt chart in Excel 2013 with the time of day as the x axis, date as the y axis and floating bars representing the length of time. Sample data:

Date    Start   End     Duration
21-Apr  6:45    8:20    1:35
21-Apr  10:00   11:30   1:30
21-Apr  14:00   16:00   2:00
22-Apr  6:50    8:40    1:50
22-Apr  11:00   11:45   0:45
22-Apr  14:00   15:00   1:00
23-Apr  6:50    8:40    1:50
23-Apr  10:50   12:15   1:25
23-Apr  14:00   14:45   0:45

Thus, my chart would have three lines (one per date), each of which would have three separate floating bars representing three durations on that day.

I know that the solution involves inserting a complex histogram and creating an invisible Start series, but I cannot get it to work. Help?

Answer 1

Excel, - VBA, , (/ , SO), , , , , Excel 2013 .

-, , Excel, , . , Start, End . .

A1: G4, , , Stacked Bar chart, . "", " ..." " /". () (, , , ).

, X , , , .