LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
WillDawg
 
Posts: n/a
Default How do I add the similar points together on the X axis

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line Drawing Between Separated Data Points ? Robert11 Charts and Charting in Excel 2 April 28th 05 11:11 AM
Plot points with same x-value in same series? smKing Charts and Charting in Excel 1 February 3rd 05 07:32 PM
space between y axis and data points.. Dave R. Charts and Charting in Excel 3 January 8th 05 04:56 AM
Newbie to charts question - projecting values between data points 38N90W Excel Discussion (Misc queries) 3 January 6th 05 05:15 AM
Points remaining formula jbsand1001 Excel Worksheet Functions 1 January 5th 05 11:11 PM


All times are GMT +1. The time now is 05:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"