Thread: Chart number of occurences

I am doing a chart of internet bandwith usage for my office. I am using logs
output from our router to a log viewer that exports the data in a spreadsheet
format. The spreadsheet contains a column with a time stamp, local IP
address, and remote IP address accessed by that local IP address. Each time
a local IP address accesses a remote address, a log entry is created. There
are litrally thousands of entries in this log each day. I need to create a
chart that shows how much usage each local ip is generating. I would prefer
a pie chart for this. The standard chart wizard is not generating the data
very accuratly. Any suggestions would be appreciated.

Try making a Pivot Table from the data, then chart this
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"David P." <DavidP@discussions.microsoft.com> wrote in message
news:42528BC5-DA7A-4DC9-98C4-2A8FB4DC097B@microsoft.com...
>I am doing a chart of internet bandwith usage for my office. I am using
>logs
> output from our router to a log viewer that exports the data in a
> spreadsheet
> format. The spreadsheet contains a column with a time stamp, local IP
> address, and remote IP address accessed by that local IP address. Each
> time
> a local IP address accesses a remote address, a log entry is created.
> There
> are litrally thousands of entries in this log each day. I need to create
> a
> chart that shows how much usage each local ip is generating. I would
> prefer
> a pie chart for this. The standard chart wizard is not generating the
> data
> very accuratly. Any suggestions would be appreciated.