+ Reply to Thread
Results 1 to 7 of 7

Productivity chart

Hybrid View

  1. #1
    Registered User
    Join Date
    07-08-2011
    Location
    Norfolk, VA
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: Something that should be easy...basic chart question

    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
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-20-2011
    Location
    Atlanta, Georgia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Something that should be easy...basic chart question

    Quote Originally Posted by Rahbee View Post
    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 data
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    01-11-2011
    Location
    Frederick, MD, USA
    MS-Off Ver
    Excel 2007
    Posts
    125

    Re: Help arranging productivity chart please

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1