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" wrote in message
...
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é