+ Reply to Thread
Results 1 to 2 of 2

Wanted To See The Department Utlization vs Number of Active people Month wise

  1. #1
    Registered User
    Join Date
    04-07-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    2

    Wanted To See The Department Utlization vs Number of Active people Month wise

    Dear Members,
    I have an urgent requirement to create a chart for my management.

    I have raw data which has the following values.
    Column A - Name of Employees
    Starting from Column B - Employee's respective utilization for each month i.e Jan, Feb, March and so on

    Now I have been asked to prepare some graphs to show the consolidated utilization of the department month wise. Ok no problem, I have done that.

    Tricky part is, I have also been asked to provide the number of active employees vs and their collective utilization for each month and I have not been able to figure out as to how to do it. What I have done in the sheet, is to insert another column and mention "Resigned or Working" for employees who do not have any utilization figures for 2/3 months (Assuming that these people have resigned) but I do not know how to put all this information together in graph. Please help.

    I have attached a test sheet here for your reference.


    PS - I apologize if I have put this thread in wrong section as I just joined the forum and have not gone through the rules. Please feel free to move it accordingly.
    Attached Files Attached Files
    Last edited by lather; 04-08-2016 at 06:56 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Pivot Table And Chart - Help Required

    title updated.
    Last edited by protonLeah; 04-08-2016 at 05:02 PM.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automating Pivot table and pivot chart creation if data table names unknown
    By Vegiepie2016 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-04-2016, 11:52 AM
  2. Pivot table filter required
    By pauldaddyadams in forum Excel General
    Replies: 9
    Last Post: 12-15-2014, 02:37 PM
  3. Trouble with geting the required data from a pivot table
    By nsmjc in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-19-2014, 02:05 AM
  4. Output required like pivot table
    By abhijit786 in forum Excel General
    Replies: 3
    Last Post: 09-19-2012, 11:52 AM
  5. [SOLVED] Pivot Table not retrieving required data
    By Excel Dumbo in forum Excel General
    Replies: 6
    Last Post: 07-19-2012, 06:25 PM
  6. Excel 2007 : PIVOT Table with Dates - Help Required
    By pgopinath in forum Excel General
    Replies: 2
    Last Post: 05-31-2012, 04:07 AM
  7. Required old format for Pivot table
    By devesh.agrawal in forum Excel General
    Replies: 2
    Last Post: 04-11-2009, 07:18 AM

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