Chart For Hiring Plan

Discussion in 'Excel Charting' started by Himanshututeja, Apr 1, 2013.

  1. Hi All,

    I have to show ramp-up plan of my team. i have prepared the database fo
    creating pivot table & chart.

    Please find attached the excel for the same. I need the chart whic
    shows the number of opening with actual + engaged.

    Two chart has been made one by Pivot table(i.e. chart A) & other CHart
    . I want to prepare Chart B with help of Pivot table.

    Thanks In Advance

    Regards
    HK


    "Position
    status" "Approval
    Status" JD Availability Project Department Need By LOI Date DO
    Date Of Joining Designation Note Note2
    Closed Approved PA1 SW 1-Jan-13 17-Jul-11 21-May-89 16-Aug-11 Engineer S
    Testing
    Closed Approved PA1 SW 1-Jan-13 18-Oct-11 26-Jan-87 17-Nov-11 Sr
    Engineer SW Testing
    Closed Approved PA1 SW 1-Jan-13 3-Mar-12 27-Aug-87 2-Apr-12 GET S
    Testing
    Closed Approved PA1 SW 1-Jan-13 6-Aug-12 30-Jul-89 5-Sep-12 GET S
    Testing
    Closed Approved PA1 SW 1-Jan-13 7-Aug-12 2-Dec-90 6-Sep-12 GET S
    Testing
    Closed Approved PA1 SW 1-Jan-13 22-Oct-12 3-Oct-89 21-Nov-12 GET S
    Testing
    Closed Approved PA1 SW 1-Jan-13 22-Oct-12 27-Jul-80 21-Nov-12 Engineer S
    Testing
    Closed Approved PA1 SW 1-Jan-13 22-Oct-12 1-Sep-89 21-Nov-12 GET S
    Testing
    Closed Approved PA1 SW 1-Jan-13 17-Jul-11 30-Dec-89 16-Aug-11 Engineer S
    Testing
    Open Approved Yes PA1 SW 1-Mar-13 Assistant Manager SW Testing
    Open Approved NO PA1 SW 1-Mar-13 Engineer SW Testing
    Open Approved Yes PA1 SW 1-Mar-13 Engineer SW Testing
    Open Approved Yes PA1 SW 1-Mar-13 Assistant Manager SW Development
    Open Approved NO PA1 SW 1-Jun-13 Engineer SW Development
    Open Approved NO PA1 SW 1-Jun-13 Sr. Engineer SW Development
    Open Approved Yes PA1 SW 1-Jul-13 1-Mar-13 1-Apr-13 GET SW Testing
    Open Approved Yes PA1 SW 1-Jul-13 Sr. Engineer SW Testing
    Open Approved Yes PA1 SW 1-Jul-13 Engineer SW Testin

    +-------------------------------------------------------------------
    |Filename: Ramp-up.jpg
    |Download: http://www.excelbanter.com/attachment.php?attachmentid=829
    +-------------------------------------------------------------------


    --
    Himanshututeja
     
    Himanshututeja, Apr 1, 2013
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.