Business Process Consultant
Operations Manager
Manager - Recruitment
+2 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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 !

Please find the updated file at the bottom of this page.
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.

Kumar M

Attached Files
Membership is required for download. Create An Account First
File Type: xls tracker_578.xls (19.0 KB, 2199 views)

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
Awaiting for your reply.
Please consider this as a urgent need.

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.

Attached Files
Membership is required for download. Create An Account First
File Type: xls example_graphs_361.xls (22.0 KB, 1204 views)

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,

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.
Kumar M

Attached Files
Membership is required for download. Create An Account First
File Type: xls tracker_updated_506.xls (47.5 KB, 1263 views)

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......
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.

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™