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!

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/P...cle.asp?ID=553

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"MP" wrote in message
...
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!