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.
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.
