Excel - Manipulating Vertical - Repetitive Data

[ladyck3]

I have a situation which I bet that Excel can easily handle, I just don't know 'yet' what tool I might use within the application to get the results that I need... easily.

See the data below:

Date Hour Standard User
6/1/2010 14 0 0
6/1/2010 15 0 0
6/1/2010 16 1 1
6/1/2010 17 1 1
6/2/2010 14 1 1
6/2/2010 15 1 1
6/2/2010 16 1 1
6/2/2010 17 1 1
6/3/2010 14 0 0
6/3/2010 15 0 0
6/3/2010 16 0 0
6/3/2010 17 0 0
6/4/2010 14 0 0
6/4/2010 15 1 1
6/4/2010 16 1 1
6/4/2010 17 0 0
6/7/2010 14 0 0
6/7/2010 15 0 0
6/7/2010 16 0 0
6/7/2010 17 0 0
6/8/2010 14 0 0
6/8/2010 15 0 0
6/8/2010 16 0 0
6/8/2010 17 0 0
6/9/2010 14 1 1
6/9/2010 15 0 0
6/9/2010 16 0 0
6/9/2010 17 0 0
6/10/2010 14 0 0
6/10/2010 15 0 0
6/10/2010 16 0 0
6/10/2010 17 0 0
6/11/2010 14 0 0
6/11/2010 15 1 1
6/11/2010 16 1 1
6/11/2010 17 0 0
6/14/2010 14 0 0
6/14/2010 15 0 0
6/14/2010 16 2 2
6/14/2010 17 2 2

This is raw data showing date by date, the hour of the day and the occurances duing the same time period daily. I need to track that in a line chart. What I am doing to accomplish this is to create a vertical daily list and then the hours 14:00, 15:00, etc are horizontal... and daily I copy and paste the occurances (copy > paste special > transpose) into two different tables... one for Standard and one for User.

There has just got to be a feature in Excel, that I do not current know exists or its there and I know it but don't know what its for or how to use it, such as a Histogram. For some reason, in my mind's eye, I'm thinking that this is what the Histrogram tool was created for but I don't know that or how to use it.

I can't visualize how a pivot chart would work for this... Could you please shed some light on this very tedious task?

Maybe I'm doing it the easiest way possible but I highly doubt it.. I believe its the easiest in my limited knowledge.

Thanks in advance,
Laurie


LadyCK3
aka: Laurie

 

[SkipVought]

Laurie,

How about a pivot table where Date is a ROW field and Hour is a COLUMN field and Standard & User are DATA fields?
[tt]
Hour
14 15 16 17
Date std usr std usr std usr std usr
6/1/2010 0 0 0 0 1 1 1 1
6/2/2010 1 1 1 1 1 1 1 1
6/3/2010 0 0 0 0 0 0 0 0
6/4/2010 0 0 1 1 1 1 0 0
6/7/2010 0 0 0 0 0 0 0 0
6/8/2010 0 0 0 0 0 0 0 0
...
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}