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.

Chart number of occurences
 

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