software

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: www.excelforum.com/member.php...oamp;userid=33162
View this thread: www.excelforum.com/showthread...hreadid=530170hi tonystowe:

not sure if you've already been helped, if not...

one potential way to get your the information you're after (non-pivottable
version) is to use the CountIf function:

1. in column E of your file, type out the unique names of the offices you
have in your list, ie Cell E1 = Office, E2 = Sales, E3 = Shipping, etc
2. setup a dynamic named range so you can count the frequency of the
relevant office (so you dont have to keep changing the range definition)
Insert -gt; Name -gt; Define -gt; Type 'Office' and under 'Refers to' type
'=offset(Sheet1!$B$2,0,0,counta($B:$B),1)
3. in F2, type in the following formula: =countif(office,quot;=quot;amp;E2)
4. Copy amp; Paste that formula down the list of your offices

** that should give the count of how many times each office name was used
in the data list**

now for your chart...

1. highlight data table with office and count
2. select Pie Chart -gt; Next -gt; Next -gt; in the data labels tab choose
Percentage -gt; Finish

i think (and hope) that is what you were looking for. please post if ws
helpful or you need additional guidance.

cheers.

quot;tonystowequot; wrote:

gt;
gt; Hello,
gt;
gt; I need your all's help and would appreciate any advice you can offer.
gt;
gt;
gt; ColA
gt; ColB ColC
gt; In Sheet1, Row1 I have the column titles of | DATE | OFFICE | REPORT
gt; |
gt;
gt; DATE is the date a specific report is given concerning a specific
gt; office.
gt;
gt; OFFICE is where I specific whom the report concerns (sales, shipping,
gt; etc)
gt;
gt; REPORT is where I write the specifics of the information given.
gt;
gt; -------------------------------------------------
gt; What I want to do
gt;
gt; I want one graph to show the total number of reported incidents by
gt; associated OFFICE in a percentile formatted Pie Chart. I do not know
gt; how to create a graph to look at Sheet1, sort the reports by OFFICE and
gt; present that data in a graph. I have read a little about Pivot tables
gt; but I do not understand them enough to get the correct answer nor will
gt; it update as I enter more lines of data.
gt;
gt;
gt; --
gt; tonystowe
gt; ------------------------------------------------------------------------
gt; tonystowe's Profile: www.excelforum.com/member.php...oamp;userid=33162
gt; View this thread: www.excelforum.com/showthread...hreadid=530170
gt;
gt;


thechilipino,

Thanks for your reply and I am trying to input your suggestions into
the sheet. If I have any questions I will post here.

Again, Thanks

Tony--
tonystowe
------------------------------------------------------------------------
tonystowe's Profile: www.excelforum.com/member.php...oamp;userid=33162
View this thread: www.excelforum.com/showthread...hreadid=530170