View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default 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.