Graphing top 10

AnWeNeT · May 22nd, 2002, 08:13 AM

Hello to all
I have simple problem (at least I think). This is how it goes:
I have virus.csv file. I know how to import it into excel, but how do I graph top 5 or 10 viruses stopped on our Internet mail gateway. I just need top results to be graphed and possibly exported to HTML format. Better yet if I could get this done, so regional managers could sort and play with the data - something like pivot tables.
Any ideas?
andrew.

Iain Lewis · May 22nd, 2002, 09:04 AM

Have you tried autofilter ? One of the options is filtering no the Top / Bottom nth.

zzydhf · May 22nd, 2002, 09:26 AM

I don't know what your data looks like, but you could try a pivot with a count of virus name. then sort it decending and graph just the top five or ten.

or you could do it with the large function and a lookup.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 08:13 AM	#1
AnWeNeT New Member Join Date: Feb 2002 Posts: 4	Hello to all I have simple problem (at least I think). This is how it goes: I have virus.csv file. I know how to import it into excel, but how do I graph top 5 or 10 viruses stopped on our Internet mail gateway. I just need top results to be graphed and possibly exported to HTML format. Better yet if I could get this done, so regional managers could sort and play with the data - something like pivot tables. Any ideas? andrew.

May 22nd, 2002, 09:04 AM	#2
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	Have you tried autofilter ? One of the options is filtering no the Top / Bottom nth.

May 22nd, 2002, 09:26 AM	#3
zzydhf Board Regular Join Date: Apr 2002 Location: N.E. Ohio Posts: 236	I don't know what your data looks like, but you could try a pivot with a count of virus name. then sort it decending and graph just the top five or ten. or you could do it with the large function and a lookup.