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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. WhyKnot

    need help with charting, scheduling plan

    WhyKnot, Jun 27, 2004, in forum: Excel Charting
    Replies:
    1
    Views:
    85
    JulieD
    Jun 27, 2004
  2. BRIAN MURPHY
    Replies:
    2
    Views:
    102
    BRIAN MURPHY
    May 30, 2005
  3. jameela
    Replies:
    1
    Views:
    75
    Barb Reinhardt
    Feb 14, 2006
  4. Mahwish

    How can i make an action Plan?

    Mahwish, Jul 8, 2006, in forum: Excel Charting
    Replies:
    0
    Views:
    66
    Mahwish
    Jul 8, 2006
  5. Paterico
    Replies:
    0
    Views:
    90
    Paterico
    Oct 4, 2006
  6. Ms. Agner

    How do I create a lesson plan template?

    Ms. Agner, Aug 19, 2007, in forum: Excel Charting
    Replies:
    1
    Views:
    129
    Del Cotter
    Aug 19, 2007
  7. Mortir

    measuring plan in % with pie chart

    Mortir, Nov 13, 2007, in forum: Excel Charting
    Replies:
    2
    Views:
    72
    John Mansfield
    Nov 13, 2007
  8. PatK

    actual vs plan chart

    PatK, Apr 1, 2009, in forum: Excel Charting
    Replies:
    0
    Views:
    77
Loading...