Chart number of occurences

[David P.]

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.

 

[Bernard Liengme]

Try making a Pivot Table from the data, then chart this
best wishes