I am making a chart for employee productivity (first time using Excel for something important since college). I have 4 employees who work on files throughout the day. My boss wants me to make a chart showing the number of times files are worked throughout the month on a line chart.
My problem is that the employees work different numbers of days in the month. How can I best represent their productivity on my chart?
Last edited by mdigeron; 07-26-2011 at 03:59 PM.
What do you want as your X and Y axis? What do you want the lines to represent? Once you answer this, you will probably be able to figure out how to structure it yourself.
See attached for example
I am supposed to represent the amount of work done each day by each employee.. for the whole month.. on one chart. Here's my example w/ gaps where people had days off. I would like the lines to be connected but when the program connects them the chart looks bad. Is there some other way to arrange the dataOriginally Posted by Rahbee
What kind of chart you use depends greatly on what information you really wish to convey. Do you want to compare the absolute outputs of each employee to each other? Or perhaps figure who's pulling the lion's share of work, in which you'd want to actually show a chart of, for example, who did the most in any given day, or other period? These are just a few examples; what your boss really wants is still unclear.
Boss has been pretty vague as to what he wants---this project was given to him and he passed it on to me. I would like to present the data in a chart that shows who is doing the most work on any given day. As it was explained to me, the COO wants to see a month's worth on one chart. The "Employee Comparison" bar chart looks like it may do that pretty well.. What do you think?
If "most work per day" is what he wants, then I'd bet that a bar chart - instead of a line chart - is likely to be the best bet. You can compare each of the four employees on a day-to-day basis that way...but you're still going to have to decide which way to do that, be it total files opened, percent of total that day, or whatever.
However, I suspect strongly that this kind of advice is outside the scope of this kind of forum, which is really more about "How do I make Excel work the way I want it?", rather than "How can I guess what my boss wants me to do?"
Correct! I appreciate the advice and agree that the bar chart represents a nice daily "snapshot". Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks