Help with automating creation of Pie Chart(s)

[MP]

I'm trying to find a way to automate the creation of a pie chart from
exported Excel files from a help desk ticket type application.

This is the typical setup:

entry# total$ type
----------------------
1 20 config
2 10 rfq
3 2 question
4 12 config


I have entries with a total (value) and a type. My main need is to be able
to run a macro or use some sort of logic statements
in order to get a small table from which the pie chart(s) can be built,
something like this.


Type Total Entries Total$
config 2 32
rfq 1 10
quest 1 2


Right now I have to build this table manually but going through each column,
counting how many entries of each type, then totalling the amounts for each
of those entries.


If anyone has some ideas or can point me to some examples on how to do this
more efficiently I would appreciate it. I need to to this weekly and doint
it manually is a BIG PAIN in the behind.

Thanks in advance!

 

[Jon Peltier]

A pivot table will compile the data into a list for you. Then you could
either make a pivot chart of the data (yech!) or a regular chart from the
pivot data. This page has some hints:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=553

- Jon