Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Line Drawing Between Separated Data Points ? | Charts and Charting in Excel | |||
Plot points with same x-value in same series? | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Points remaining formula | Excel Worksheet Functions |