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é

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é

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

Fré

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

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/
_______

"Frederik Vanderhaeghe" wrote in message
...
Well, I have never done something like this, but how can you read data
from a log file into excel?

Fré

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