Time on X axis, and Dates on Y axis

[Shinano]

Educate me, oh brilliant minds! Please!

I have four columns with data: One with variable time stamps; one column with dates; and two with fixed values; and a column with the hour stamps: 00:00 through to 23:59.

1) Start time: HH:MM, a constant value
2) Stop time: HH:MM, a constant value
3) Delivery time: HH:MM, a variable value

I am trying to make a visual presentation where I have hour stamps on the X axis, and dates on the Y axis.

Start time to be presented a vertical line perpendicular to the X axis.

Stop time to likewise a vertical line perpendicular the X axis.

Delivery time being a series of dots falling either in-between the start and stop lines, or out side, depending on the value.

I have worked out how to do it the other way around, with dates on the X axis and hour stamps on the Y axis. As a result I have two horizontal lines. One for start time and one for stop time, and delivery time as dots floating either above, between or below the two lines. However, I need a solution that basically turns this result 90 degrees clock-wise.

-Any ideas? Please help me out.

Thank you very much in advance.

 

[rlv01]

However, I need a solution that basically turns this result 90 degrees clock-wise.

One way:

Rotate charts in Excel - spin bar, column, pie and line charts

How to rotate a chart in Excel 2016, 2013, 2010. Spin and flip different types of charts: bar, column, pie and line.

www.ablebits.com