Chart For Hiring Plan

[himanshututeja]

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</SPAN>	Approval Status</SPAN>	JD Availability</SPAN>	Project </SPAN>	Department </SPAN>	Need By </SPAN>	LOI Date </SPAN>	DOB </SPAN>	Date Of Joining</SPAN>	Designation</SPAN>	Note </SPAN>	Note2</SPAN>
Closed</SPAN>	Approved</SPAN>		PA1</SPAN>	SW</SPAN>	1-Jan-13</SPAN>	17-Jul-11</SPAN>	########</SPAN>	16-Aug-11</SPAN>	Engineer</SPAN>	SW Testing </SPAN>
Closed</SPAN>	Approved</SPAN>		PA1</SPAN>	SW</SPAN>	1-Jan-13</SPAN>	18-Oct-11</SPAN>	26-Jan-87</SPAN>	17-Nov-11</SPAN>	Sr. Engineer</SPAN>	SW Testing </SPAN>
Closed</SPAN>	Approved</SPAN>		PA1</SPAN>	SW</SPAN>	1-Jan-13</SPAN>	3-Mar-12</SPAN>	########</SPAN>	2-Apr-12</SPAN>	GET</SPAN>	SW Testing </SPAN>
Closed</SPAN>	Approved</SPAN>		PA1</SPAN>	SW</SPAN>	1-Jan-13</SPAN>	6-Aug-12</SPAN>	30-Jul-89</SPAN>	5-Sep-12</SPAN>	GET</SPAN>	SW Testing </SPAN>
Closed</SPAN>	Approved</SPAN>		PA1</SPAN>	SW</SPAN>	1-Jan-13</SPAN>	7-Aug-12</SPAN>	2-Dec-90</SPAN>	6-Sep-12</SPAN>	GET</SPAN>	SW Testing </SPAN>
Closed</SPAN>	Approved</SPAN>		PA1</SPAN>	SW</SPAN>	1-Jan-13</SPAN>	22-Oct-12</SPAN>	3-Oct-89</SPAN>	21-Nov-12</SPAN>	GET</SPAN>	SW Testing </SPAN>
Closed</SPAN>	Approved</SPAN>		PA1</SPAN>	SW</SPAN>	1-Jan-13</SPAN>	22-Oct-12</SPAN>	27-Jul-80</SPAN>	21-Nov-12</SPAN>	Engineer</SPAN>	SW Testing </SPAN>
Closed</SPAN>	Approved</SPAN>		PA1</SPAN>	SW</SPAN>	1-Jan-13</SPAN>	22-Oct-12</SPAN>	1-Sep-89</SPAN>	21-Nov-12</SPAN>	GET</SPAN>	SW Testing </SPAN>
Closed</SPAN>	Approved</SPAN>		PA1</SPAN>	SW</SPAN>	1-Jan-13</SPAN>	17-Jul-11</SPAN>	########</SPAN>	16-Aug-11</SPAN>	Engineer</SPAN>	SW Testing </SPAN>
Open</SPAN>	Approved</SPAN>	Yes</SPAN>	PA1</SPAN>	SW</SPAN>	1-Mar-13</SPAN>				Assistant Manager </SPAN>	SW Testing </SPAN>
Open</SPAN>	Approved</SPAN>	NO</SPAN>	PA1</SPAN>	SW</SPAN>	1-Mar-13</SPAN>				Engineer</SPAN>	SW Testing </SPAN>
Open</SPAN>	Approved</SPAN>	Yes</SPAN>	PA1</SPAN>	SW</SPAN>	1-Mar-13</SPAN>				Engineer</SPAN>	SW Testing </SPAN>
Open</SPAN>	Approved</SPAN>	Yes</SPAN>	PA1</SPAN>	SW</SPAN>	1-Mar-13</SPAN>				Assistant Manager </SPAN>	SW Development</SPAN>
Open</SPAN>	Approved</SPAN>	NO</SPAN>	PA1</SPAN>	SW</SPAN>	1-Jun-13</SPAN>				Engineer</SPAN>	SW Development</SPAN>
Open</SPAN>	Approved</SPAN>	NO</SPAN>	PA1</SPAN>	SW</SPAN>	1-Jun-13</SPAN>				Sr. Engineer</SPAN>	SW Development</SPAN>
Open</SPAN>	Approved</SPAN>	Yes</SPAN>	PA1</SPAN>	SW</SPAN>	1-Jul-13</SPAN>	1-Mar-13</SPAN>		1-Apr-13</SPAN>	GET</SPAN>	SW Testing </SPAN>
Open</SPAN>	Approved</SPAN>	Yes</SPAN>	PA1</SPAN>	SW</SPAN>	1-Jul-13</SPAN>				Sr. Engineer</SPAN>	SW Testing </SPAN>
Open</SPAN>	Approved</SPAN>	Yes</SPAN>	PA1</SPAN>	SW</SPAN>	1-Jul-13</SPAN>				Engineer</SPAN>	SW Testing </SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL span=2><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>