Thanks to all for your replies. I've got it sorted now.

Duncs

On Jul 7, 2:36*pm, BobT wrote:
You first need to do a grouping (a.k.a. subtotal) of the data. *Once that is
done (with a Count on the time range - which needs to be formatted to allow a
group by hours (i.e. drop the mintes)) then you can chart away and show
bars/lines per region by the hour.



"Duncs" wrote:
All,

I don't know if this is possible, but here goes.

I have a number of entries in a spreadsheet, showing me date / time of
access and a site. *For example:

01-07-2008 09:15:34 * * Aberdeen
01-07-2008 09:15:37 * * Aberdeen
01-07-2008 10:10:10 * * Glasgow
etc.

What I need to show is a graph that lists the number of users, per
site and per hour that accessed the system. *So, in the above example,
two columns / entries would be shown on the graph with Aberdeen having
a count of 2 for the period 09:00 until 09:59 and Glasgow showing 0.

Then, in the second column, Aberdeen would show 0 for the period 10:00
until 10:59 and Glasgow would show one.

Is this possible?

TIA

Duncs- Hide quoted text -

- Show quoted text -