Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
*.tmp file creation in Excel | Excel Discussion (Misc queries) | |||
Excel / XMI Creation | Excel Discussion (Misc queries) | |||
Form Creation in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel chart creation | Excel Discussion (Misc queries) | |||
Hyperlink Creation in Excel X for Mac | Excel Worksheet Functions |