Charting for a certain timeframe

  • Thread starter Thread starter dok112
  • Start date Start date
D

dok112

Hello,

I am learning the in's and outs of excel and charting and need som
help. I have a series of numbers that correlate to a time. I need t
chart it based on the hour it falls in, and am having very little luck
Can anyone help please? Below is the data that I have

Type.......CG.........RET........OTH.......DATE........TIME
CG............1...........0............0........10/10........16:40
OT............0...........0............1........10/10........17:09
CG............1...........0............0........10/10........17:20
RET..........0............1............0........10/10........18:01
CG...........1............0............0.........10/10......18:19

...etc...

I would like to create a bar or line graph that represents the amoun
of each type (CG,OT,RET) for each hour (4P, 5P, 6P)....any help will b
greatly appreciated..
 
Hi dok,

You can use a Pivot Table to Group the time interval in hourly increments.

If you need more help, email me separately and I will send you a workbook
that shows how to do this.

Ed Ferrero
http://edferrero.m6.net
 
Back
Top