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
From India, Madras
Acknowledge(0)
Amend(0)
1I 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
From India, Madras
Acknowledge(0)Amend(0)
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.
Regards
Kumar M
From India
Acknowledge(0)Amend(0)
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.
Regards
Kumar M
From India
Acknowledge(0)Amend(0)
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
From India, Madras
Acknowledge(0)Amend(0)
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
From India, Madras
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
From India, New Delhi
Acknowledge(0)Amend(0)
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
From India, New Delhi
Acknowledge(0)Amend(0)
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
From India
Acknowledge(0)Amend(0)
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
From India
Acknowledge(0)Amend(0)
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
From India
Acknowledge(0)Amend(0)
Regards
Kumar M
From India
Acknowledge(0)Amend(0)
Hey Friends, I hav got good stuff in this site. Both excel sheets were excellent!! Good work. Regards Manisha
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Much Appreciated ! good work, it helped a bunch, sampled your idea and used it to make one for my work ! regards
From Pakistan, Lahore
Acknowledge(0)Amend(0)
From Pakistan, Lahore
Acknowledge(0)Amend(0)
Dear,
I am a Human Resource professional working with small organizations. I want to create and generate staff IDs in the organization. If anyone can help me in preparing an Excel sheet to generate staff IDs or resource numbers, it would make it easier for me to edit the given format.
Thanks
From Somalia, undefined
Acknowledge(0)Amend(0)
I am a Human Resource professional working with small organizations. I want to create and generate staff IDs in the organization. If anyone can help me in preparing an Excel sheet to generate staff IDs or resource numbers, it would make it easier for me to edit the given format.
Thanks
From Somalia, undefined
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Create bell curve in XL.doc
Create Your Own face.xls