Charting Email Viruses

[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

 

[Ed Ferrero]

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