Chart For Hiring Plan
1 Attachment(s)
Hi All,
I have to show ramp-up plan of my team. i have prepared the database for creating pivot table & chart. Please find attached the excel for the same. I need the chart which shows the number of opening with actual + engaged. Two chart has been made one by Pivot table(i.e. chart A) & other CHart B . 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 DOB Date Of Joining Designation Note Note2 Closed Approved PA1 SW 1-Jan-13 17-Jul-11 21-May-89 16-Aug-11 Engineer SW 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 SW Testing Closed Approved PA1 SW 1-Jan-13 6-Aug-12 30-Jul-89 5-Sep-12 GET SW Testing Closed Approved PA1 SW 1-Jan-13 7-Aug-12 2-Dec-90 6-Sep-12 GET SW Testing Closed Approved PA1 SW 1-Jan-13 22-Oct-12 3-Oct-89 21-Nov-12 GET SW Testing Closed Approved PA1 SW 1-Jan-13 22-Oct-12 27-Jul-80 21-Nov-12 Engineer SW Testing Closed Approved PA1 SW 1-Jan-13 22-Oct-12 1-Sep-89 21-Nov-12 GET SW Testing Closed Approved PA1 SW 1-Jan-13 17-Jul-11 30-Dec-89 16-Aug-11 Engineer SW 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 Testing |
All times are GMT +1. The time now is 11:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com