Making charts from log files

[Frederik Vanderhaeghe]

Hi,

I'm using Microsoft Sharepoint Services and i would like to get charts from
my site usage. Everyday there are 3 log files made automatically.
How can I get the data out of the log files into excel and then make charts
from it like 'document x has been opended y times by user z'

I would like that the charts are automatically made and shown in my site.

Fré

 

[Jon Peltier]

It's probably best to first design a template with some dummy data and some
charts. You will need to import the log files into a workbook based on this
template, knowing what format they are in. The new data should overwrite the
dummy data. Any formulas (or pivot tables) should be updates, and if
designed properly, the charts will update themselves.

This is a much larger task than a newsgroup reply can answer, but the
approach outlined above is what is required. You could get started on this,
and follow up with specific questions as you piece the program together.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Excel Programming
http://PeltierTech.com/
_______

 

[Frederik Vanderhaeghe]

Well, I have never done something like this, but how can you read data from
a log file into excel?

Fré

 

[Jon Peltier]

Presumably the log file is a text file. Open Excel, and drag the file from
Windows Explorer onto the Excel window; alternatively use File > Open,
change the file type to All Files, browse to the log file, and open it. The
import text dialog may open, or the data may just get dumped into a blank
worksheet, and you can use text-to-columns (data menu) to split it up.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______