How do I add the similar points together on the X axis

[WillDawg]

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?

 

[Bernard Liengme]

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 D135 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 D135

 

[Bernard Liengme]

That should be: Chart D1:E35 of course

 

[bj]

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

 

[WillDawg]

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