#1   Report Post  
Johnfli
 
Posts: n/a
Default creating a bar graph

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a graph JF Excel Worksheet Functions 4 October 23rd 05 01:07 AM
creating a graph from nominal (non-numeric) data in Excel? Chris Charts and Charting in Excel 1 October 1st 05 02:37 PM
Creating a bar graph manually WLMPilot Excel Worksheet Functions 5 June 23rd 05 07:00 PM
Creating a line graph from 2 pivot tables? gmodi Charts and Charting in Excel 3 March 7th 05 03:09 PM
creating a directed graph from XY scatter Luke Spar UTAFortWorth Charts and Charting in Excel 11 January 25th 05 05:24 AM


All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"