site visits statistics with excel

[jumpjack]

I have a log file containing one line per site visit.
How do I build an excel graph showing how day visits change during the year, without using macro?
First cell of each line contains date and time of visit.

[ChemistB]

You want to familiarize yourself with Pivot Tables. You can Group Pivot Table dates by Month or Quarter. Sounds like you want to separate out the dates and times too.

Insert 2 blank columns (let's say B and C)
Format B as date and use (in B2)
=INT(A2) copied down
Format C as Time and use (in C2)
=MOD(A2,1)
Hope that helps.

[jumpjack]

You want to familiarize yourself with Pivot Tables. You can Group Pivot Table dates by Month or Quarter. Sounds like you want to separate out the dates and times too.

I often received hints about using pivot to solve this issue, but I always gave up after looking stuff to study to understand pivot tbales!

Now, I found this video, and with two click I solved the issue!
You don't need to know italian o to listen at the whole video... just start viewing it from 3:24!!
http://www.youtube.com/watch?feature...Lr5Y2lo#t=208s