J
Johnfli
I have almost ZERO experience with making graphs. But I need to do this one
graph.
I have a worksheet that has various times and dates
For example:
DATE PORT TERMINAL OCEAN CARRIER TRANSACTION TYPE Single = 1 Dual =
2 EMPTY CONTAINER # IN LOADED CONTAINER # OUT WHEELED/GROUNDED (W/G) TIME
ARRIVED IN LINE PEAK TIME ARRIVED IN LINE OFF PEAK TIME ARRIVED AT GATE
TIME EMPTY RETURNED TIME FULL PICKED UP TIME OUT GATE ELAPSED TIME PEAK
ELAPSED TIME OFF PEAK COMMENTS
10/14/2005 LA B234 KLINE 2 KKFU7218184 W 13:35 13:35 13:40 13:48
0:13 DTNT
10/14/2005 LA B234 KLINE 1 KLFU1848657 W 15:50 15:50 19:19 16:19
0:29
10/14/2005 LA B234 KLINE 2 KKFU1357310 W 11:31 11:31 11:40 11:51
0:20
10/14/2005 LA B234 KLINE 2 KKFU7179935 W 8:55 8:55 9:10 9:10
0:15
10/14/2005 LA B234 KLINE 2 KKFU9085080 W 13:10 13:10 13:14 13:18
0:08
October 359 W AVG 0:34 0:23
What I need to do is have a graph that displayes the Average ELAPSED TIME
(Column O :34 min in this example)
For the follow criteria:
Section named Day
When "TIME ARRIVED IN LINE" (Column I) is between 3:01am and 5:00pm and the
DATE (column A) is not Saturday or SUnday and Column H is a 'W' and Column E
is a '1' .
ANother Bar that shows
When "TIME ARRIVED IN LINE" (Column I) is between 3:01am and 5:00pm and the
DATE (column A) is not Saturday or SUnday and Column H is a 'W' and Column E
is a '2' .
Another bar that shows
When "TIME ARRIVED IN LINE" (Column I) is between 3:01am and 5:00pm and the
DATE (column A) is not Saturday or SUnday and Column H is a 'G' and Column E
is a '1' .
ANother Bar that shows
When "TIME ARRIVED IN LINE" (Column I) is between 3:01am and 5:00pm and the
DATE (column A) is not Saturday or SUnday and Column H is a 'G' and Column E
is a '2' .
Section Named Night
Another bar that shows
When "TIME ARRIVED IN LINE" (Column I) is between 5:01pm and 3:00AM and the
DATE (column A) is not Saturday or SUnday and Column H is a 'W' and Column E
is a '1' .
ANother Bar that shows
When "TIME ARRIVED IN LINE" (Column I) is between 5:01pm and 3:00AM and the
DATE (column A) is not Saturday or SUnday and Column H is a 'W' and Column E
is a '2' .
Another bar that shows
When "TIME ARRIVED IN LINE" (Column I) is between 5:01pm and 3:00AM and the
DATE (column A) is not Saturday or SUnday and Column H is a 'G' and Column E
is a '1' .
ANother Bar that shows
When "TIME ARRIVED IN LINE" (Column I) is between 5:01pm and 3:00AM and the
DATE (column A) is not Saturday or SUnday and Column H is a 'G' and Column E
is a '2' .
Section Named Weekend
Another bar that shows
When the DATE (column A) is not Saturday or SUnday and Column H is a 'W' and
Column E is a '1' .
ANother Bar that shows
When the DATE (column A) is not Saturday or SUnday and Column H is a 'W'
and Column E is a '2' .
Another bar that shows
When the DATE (column A) is not Saturday or SUnday and Column H is a 'G'
and Column E is a '1' .
ANother Bar that shows
When the DATE (column A) is not Saturday or SUnday and Column H is a 'G' and
Column E is a '2' .
Another bar that shows
I majorly appreciate any and all help on this. Like I said, I no know
nothing about graphing and wouldn't know where to start.
So I will have one worksheet that has 12 Bars in it
graph.
I have a worksheet that has various times and dates
For example:
DATE PORT TERMINAL OCEAN CARRIER TRANSACTION TYPE Single = 1 Dual =
2 EMPTY CONTAINER # IN LOADED CONTAINER # OUT WHEELED/GROUNDED (W/G) TIME
ARRIVED IN LINE PEAK TIME ARRIVED IN LINE OFF PEAK TIME ARRIVED AT GATE
TIME EMPTY RETURNED TIME FULL PICKED UP TIME OUT GATE ELAPSED TIME PEAK
ELAPSED TIME OFF PEAK COMMENTS
10/14/2005 LA B234 KLINE 2 KKFU7218184 W 13:35 13:35 13:40 13:48
0:13 DTNT
10/14/2005 LA B234 KLINE 1 KLFU1848657 W 15:50 15:50 19:19 16:19
0:29
10/14/2005 LA B234 KLINE 2 KKFU1357310 W 11:31 11:31 11:40 11:51
0:20
10/14/2005 LA B234 KLINE 2 KKFU7179935 W 8:55 8:55 9:10 9:10
0:15
10/14/2005 LA B234 KLINE 2 KKFU9085080 W 13:10 13:10 13:14 13:18
0:08
October 359 W AVG 0:34 0:23
What I need to do is have a graph that displayes the Average ELAPSED TIME
(Column O :34 min in this example)
For the follow criteria:
Section named Day
When "TIME ARRIVED IN LINE" (Column I) is between 3:01am and 5:00pm and the
DATE (column A) is not Saturday or SUnday and Column H is a 'W' and Column E
is a '1' .
ANother Bar that shows
When "TIME ARRIVED IN LINE" (Column I) is between 3:01am and 5:00pm and the
DATE (column A) is not Saturday or SUnday and Column H is a 'W' and Column E
is a '2' .
Another bar that shows
When "TIME ARRIVED IN LINE" (Column I) is between 3:01am and 5:00pm and the
DATE (column A) is not Saturday or SUnday and Column H is a 'G' and Column E
is a '1' .
ANother Bar that shows
When "TIME ARRIVED IN LINE" (Column I) is between 3:01am and 5:00pm and the
DATE (column A) is not Saturday or SUnday and Column H is a 'G' and Column E
is a '2' .
Section Named Night
Another bar that shows
When "TIME ARRIVED IN LINE" (Column I) is between 5:01pm and 3:00AM and the
DATE (column A) is not Saturday or SUnday and Column H is a 'W' and Column E
is a '1' .
ANother Bar that shows
When "TIME ARRIVED IN LINE" (Column I) is between 5:01pm and 3:00AM and the
DATE (column A) is not Saturday or SUnday and Column H is a 'W' and Column E
is a '2' .
Another bar that shows
When "TIME ARRIVED IN LINE" (Column I) is between 5:01pm and 3:00AM and the
DATE (column A) is not Saturday or SUnday and Column H is a 'G' and Column E
is a '1' .
ANother Bar that shows
When "TIME ARRIVED IN LINE" (Column I) is between 5:01pm and 3:00AM and the
DATE (column A) is not Saturday or SUnday and Column H is a 'G' and Column E
is a '2' .
Section Named Weekend
Another bar that shows
When the DATE (column A) is not Saturday or SUnday and Column H is a 'W' and
Column E is a '1' .
ANother Bar that shows
When the DATE (column A) is not Saturday or SUnday and Column H is a 'W'
and Column E is a '2' .
Another bar that shows
When the DATE (column A) is not Saturday or SUnday and Column H is a 'G'
and Column E is a '1' .
ANother Bar that shows
When the DATE (column A) is not Saturday or SUnday and Column H is a 'G' and
Column E is a '2' .
Another bar that shows
I majorly appreciate any and all help on this. Like I said, I no know
nothing about graphing and wouldn't know where to start.
So I will have one worksheet that has 12 Bars in it