Totaling Hits by the hour

  • Thread starter Thread starter neuroelectronic
  • Start date Start date
N

neuroelectronic

I have a dataset with the date and time of my website hits each in
seperate colum.

I want to create a graph of how many hits I get an hour (currentl
beween 0-10) threwout the week.

Really I have no idea where to begin. Im guessing I would have t
create a graph from a report but how would I make a report like thi
from this data
 
if the times of the hits are in a1:a100

asuming you list all hours in d1:d100, place this in e1 and copy down

=sumproduct((a1:a100>=d1)*(a1:a100<d2)
 
Add a third column and call it 'Hour'.

Assuming your data is in A2:B100 with the time being in Col B, then in C2 put
the following formula and copy down:-

=TIME(HOUR(B2),0,0)

Now select all your data, do Data / Pivot table and Chart report, hit Next /
Next / Finish

Drag 'Date' to the ROW fields
Drag 'Hour' to the COLUMN fields
Drag 'Hour' to the DATA field

For a graph just hit the Graph Button whilst in the Pivot Table.
 
Without adding any additional information, one idea is to make a Pivot
Table.
In your Pivot Table, right click your date column, and select Group. Select
both "Days" and "Hours" for your grouping.

HTH
Dana DeLouis
 
Back
Top