Create A Graph-Track Of Employees Who Joined/resigned

Dear All,
I am creating a graph on the number of employees who are working and number of employees who have resigned. The graph should also show the number of employees in each and every department like Engineering department, QC department, Sales department etc.,.
I would appreciate if any of you can share any formats like this... to maintain a track of the percentage of employees are existing and who have quit.
This woould be useful for many HR's working in a small company too.
Expecting a reply !
Regards
Jitha

Please find the updated file at the bottom of this page.
Hi,
Please find attached .xls file probable it could solve your problem, There are asome flaws in it, but I hope you can manage it for the time being.
You just need to make change in the Current Status column in any sheet and the rest is taken care.
It is based on Department wise, the whole organization and then depicted in a graph format.
For any further clarifications, pls mail me at the e-mail given below.
[Login to view]
Regards
Kumar M
[Login to view]

Hi Kumar,
This is Jitha from Chennai. I got the .xls sheet called "Tracker" which you sent.
I have started working on it. We have nearly 8 departments and I am trying to
create with the help of your tracker. But I do not have any idea how the formula
for different sheets(departments) can be made and also the graph. If I try inserting,
it is showing error. I think the excel will accept only two sheets to work out.
Can you please suggest/help me to create a formula if i am adding more sheets in the
excel.
Awaiting for your reply.
Please consider this as a urgent need.
Thanks,
Jitha

Hi Jitha,
You might need to look at a Bar chart rather than a Pie Chart.
Each Column will represent a Department and two bars will be representing the % of Existing Employees and % of Resigned Employees.
I am attaching an excel file for your reference.
To answer your second query, excel works with logic. You cannot depend on Formula for a long time. As a work around, you might insert additional in between the existing rows and the same would be reflected in your graph. There are two worksheets; one with normal situation, the other one in case you want to add something which is highlighted in yellow.
Please let me know if it helps.
Manmath
[Login to view]

Hi Kumar / Acharya,
Thats really wonderful, like you if ever one helps each other I believe there won't be problems but more of solutions before problems can arise ( we will have a choice of solutions at that time :D )
Well nothing commenting, it was really wonderful as I was browsing the sites I came across a nice site like this and able to meet wonderful people like you who are helping others.....
I even need your help to grow up in my career please help me out.....
Thanks & Warm Regards,
Sunil
[Login to view]

Hi Guys,
Very Good Morning,
Here is the updated version of the Tracker now with additional features.
We now support 9 Departments.
Each department can accomodate any number of employees.
Each dept has its own graphical output.
Hope this is useful to you......
Last but not the least thanks for the compliments Sunil.
Regards
Kumar M

Hang on one bug in the file is that you have to always enter an new record in between 1-11 rows only. and update the S.no column, Any way I am working on that to fix it..till then take care......
Regards
Kumar M

Hey Friends,
I hav got good stuff in this site. Both excel sheets were excellent!! Good work.
Regards
Manisha

Much Appreciated ! good work, it helped a bunch, sampled your idea and used it to make one for my work !
regards

Dear I am a Human Resource person working with small organizations. I want to create and generate staff ID in the organization, if anyone can help me in excel sheet prepared and generated Staff ID or resource number this will make easy for me to edit the given format.
Thanks