I manage a staff of 35 people and each has to be issued multiple purcheus
orders during the courst of the year. In order to keep trak of whom on my
staff has which po I have inputted each po number in to an Excel sperad
sheet. As my staff checks them out I put their names next to the number
along with the amount they have been issued. Right now I am trying to make a
bar graph to see how much each of my staff members has checked out, but I
only want to end up with 35 bars (to see each persons total) not 286 bars
(the numbers of pos issued so far).

So my question is: Is there any way to have Excel add all the data points
assoicated with person A together, person B, etc. while making a chart? Or
will I have to dig through my list and add each person's up myself then make
a chart of that?

Let's say the PO numbers are in column A (A1:A1000) - it does not matter if
there are blanks at end; and staff name in B1:B1000
In D1:D35 type in staff names in what ever order you want on the chart
In E1 enter =COUNTIF(B1:B1000,D1) and copy down to E35
Chart the data in D1:D35
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"WillDawg" wrote in message
...
I manage a staff of 35 people and each has to be issued multiple purcheus
orders during the courst of the year. In order to keep trak of whom on my
staff has which po I have inputted each po number in to an Excel sperad
sheet. As my staff checks them out I put their names next to the number
along with the amount they have been issued. Right now I am trying to
make a
bar graph to see how much each of my staff members has checked out, but I
only want to end up with 35 bars (to see each persons total) not 286 bars
(the numbers of pos issued so far).

So my question is: Is there any way to have Excel add all the data points
assoicated with person A together, person B, etc. while making a chart?
Or
will I have to dig through my list and add each person's up myself then
make
a chart of that?

That should be: Chart D1:E35 of course
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bernard Liengme" wrote in message
...
Let's say the PO numbers are in column A (A1:A1000) - it does not matter
if there are blanks at end; and staff name in B1:B1000
In D1:D35 type in staff names in what ever order you want on the chart
In E1 enter =COUNTIF(B1:B1000,D1) and copy down to E35
Chart the data in D1:D35
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"WillDawg" wrote in message
...
I manage a staff of 35 people and each has to be issued multiple purcheus
orders during the courst of the year. In order to keep trak of whom on
my
staff has which po I have inputted each po number in to an Excel sperad
sheet. As my staff checks them out I put their names next to the number
along with the amount they have been issued. Right now I am trying to
make a
bar graph to see how much each of my staff members has checked out, but I
only want to end up with 35 bars (to see each persons total) not 286 bars
(the numbers of pos issued so far).

So my question is: Is there any way to have Excel add all the data points
assoicated with person A together, person B, etc. while making a chart?
Or
will I have to dig through my list and add each person's up myself then
make
a chart of that?

I would suggest absolute reference for the table
=COUNTIF($B$1:$B$1000,D1)

"Bernard Liengme" wrote:

Let's say the PO numbers are in column A (A1:A1000) - it does not matter if
there are blanks at end; and staff name in B1:B1000
In D1:D35 type in staff names in what ever order you want on the chart
In E1 enter =COUNTIF(B1:B1000,D1) and copy down to E35
Chart the data in D1:D35
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"WillDawg" wrote in message
...
I manage a staff of 35 people and each has to be issued multiple purcheus
orders during the courst of the year. In order to keep trak of whom on my
staff has which po I have inputted each po number in to an Excel sperad
sheet. As my staff checks them out I put their names next to the number
along with the amount they have been issued. Right now I am trying to
make a
bar graph to see how much each of my staff members has checked out, but I
only want to end up with 35 bars (to see each persons total) not 286 bars
(the numbers of pos issued so far).

So my question is: Is there any way to have Excel add all the data points
assoicated with person A together, person B, etc. while making a chart?
Or
will I have to dig through my list and add each person's up myself then
make
a chart of that?

Thank you both for your help. This provided me with a great start point to
do further work.