Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a graph | Excel Worksheet Functions | |||
creating a graph from nominal (non-numeric) data in Excel? | Charts and Charting in Excel | |||
Creating a bar graph manually | Excel Worksheet Functions | |||
Creating a line graph from 2 pivot tables? | Charts and Charting in Excel | |||
creating a directed graph from XY scatter | Charts and Charting in Excel |