Chart for events per unit of time???

  • Thread starter Thread starter Quin
  • Start date Start date
Q

Quin

I would like to create a graph that indicates Aircraft Departures per unit of
time at the airport. I have access to flight departure times for every
aircraft so my list of data would be something like:

07:00 American
07:06 American
0712 United
0800 Allegiant
10:00 Delta
12:30 Southwest

And so on for a days worth of flights. (Probably 50 or more)

The goal is to graphically show what hours of the day have the most
activity. In my example my chart would indicate the time period around 07:00
in the morning has more departure activity than 12:00 Noon.

Any suggestions on how to proceed?

Quin
 
This is a job for a pivot table. Label your columns Time and Airline. Select
the data and create a Pivot Table (Data menu or, I think, Data tab on the
Ribbon). Drag Time into the Rows area, then again drag Time into the Data
area. So far this lists the input times with a 1 next to each, but you can
group times. Right click on the Time field button in the PT, choose Group
and Show Detail > Group, select appropriate starting and ending times, then
in the list of time periods select Hours:

7 AM 3
8 AM 1
10 AM 1
12 PM 1

Now chart it however you want.

- Jon
 
Jon,
Thanks, excellent answer with nice detail. I had an idea a Pivot Table
would be a possibility but I was not aware I could "group" the time periods
to make it practical. This is going to be really helpful to me!
Quin
 
Back
Top