Charting Email Viruses

  • Thread starter Thread starter Alex Leibovici
  • Start date Start date
A

Alex Leibovici

Hi

I have very little experience with Excel graphs and I would appreciate
some help.

I have a table with dates and times when a virus was intercepted by
our virus checker program. It goes from 2001 to present and has about
30'000 entries :-( A fragment is listed below.

I would like to plot the number of arrivals of each virus vs time, and
also a combined graph with each and all viruses vs time. The time
granularity could be weeks or months, but also hours.

=====================================
Date Time Virus
24.01.2002 15:59 Hybris
24.01.2002 17:00 Hybris
24.01.2002 23:06 Badtrans.B
24.01.2002 23:34 Badtrans.B
28.01.2002 18:57 Sircam.A
28.01.2002 19:01 Sircam.A
28.01.2002 19:02 Sircam.A
28.01.2002 19:07 Hybris
28.01.2002 19:07 Sircam.A
29.01.2002 01:27 Sircam.A
29.01.2002 01:32 Sircam.A
....... ..... ........
=====================================

TIA

Alex
 
Hi Alex,

Combine the Date and Time into one field.

If date is in cell A2, and Time in cell B2, then combine with
this formula to get an Excel date/time serial number
=DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2))+B2

Build a Pivot Chart with date/time as a row field and
Count of Virus as the data field. Then Group the date/time
field into hours, days, months etc.

Ed Ferrero
http://edferrero.m6.net
 
Back
Top