Hello,

I need your all's help and would appreciate any advice you can offer.


ColA
ColB ColC
In Sheet1, Row1 I have the column titles of | DATE | OFFICE | REPORT
|

DATE is the date a specific report is given concerning a specific
office.

OFFICE is where I specific whom the report concerns (sales, shipping,
etc)

REPORT is where I write the specifics of the information given.

-------------------------------------------------
What I want to do

I want one graph to show the total number of reported incidents by
associated OFFICE in a percentile formatted Pie Chart. I do not know
how to create a graph to look at Sheet1, sort the reports by OFFICE and
present that data in a graph. I have read a little about Pivot tables
but I do not understand them enough to get the correct answer nor will
it update as I enter more lines of data.


--
tonystowe
------------------------------------------------------------------------
tonystowe's Profile: http://www.excelforum.com/member.php...o&userid=33162
View this thread: http://www.excelforum.com/showthread...hreadid=530170