Dear All,
I am creating a graph on the number of employees who are working and the number of employees who have resigned. The graph should also show the number of employees in each department such as the Engineering department, QC department, Sales department, etc.
I would appreciate it if any of you could share any formats like this to maintain a track of the percentage of employees who are existing and who have quit. This would be useful for many HR professionals working in small companies 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 the number of employees who have resigned. The graph should also show the number of employees in each department such as the Engineering department, QC department, Sales department, etc.
I would appreciate it if any of you could share any formats like this to maintain a track of the percentage of employees who are existing and who have quit. This would be useful for many HR professionals working in small companies too.
Expecting a reply!
Regards, Jitha
From India, Madras
Acknowledge(0)Amend(0)
Please find the updated file at the bottom of this page.
Please find attached .xls file. Probably it could solve your problem. There are some flaws in it, but I hope you can manage it for the time being. You just need to make a change in the Current Status column in any sheet, and the rest is taken care of. It is based on Department-wise, the whole organization, and then depicted in a graph format.
For any further clarifications, please email me at the email given below: kumar.exe@gmail.com.
Regards,
Kumar M
kumar.exe@gmail.com
From India
Acknowledge(0)Amend(0)
Please find attached .xls file. Probably it could solve your problem. There are some flaws in it, but I hope you can manage it for the time being. You just need to make a change in the Current Status column in any sheet, and the rest is taken care of. It is based on Department-wise, the whole organization, and then depicted in a graph format.
For any further clarifications, please email me at the email given below: kumar.exe@gmail.com.
Regards,
Kumar M
kumar.exe@gmail.com
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 an 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 your reply. Please consider this an 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 an 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 your reply. Please consider this an 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 represent 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 a formula for a long time. As a workaround, you might insert additional rows between the existing rows, and the same would be reflected in your graph. There are two worksheets: one with the normal situation, the other one in case you want to add something 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 represent 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 a formula for a long time. As a workaround, you might insert additional rows between the existing rows, and the same would be reflected in your graph. There are two worksheets: one with the normal situation, the other one in case you want to add something highlighted in yellow.
Please let me know if it helps.
Manmath
Acknowledge(0)Amend(0)
Hi Kumar / Acharya,
That's really wonderful. Like you, if everyone helps each other, I believe there won't be problems but more solutions before problems arise (we will have a choice of solutions at that time :D).
Well, nothing to comment, it was really wonderful. As I was browsing the sites, I came across a nice site like this and was able to meet wonderful people like you who are helping others.
I even need your help to grow in my career. Please help me out.
Thanks & Warm Regards,
Sunil
hrd.contact@gmail.com
From India, New Delhi
Acknowledge(0)Amend(0)
That's really wonderful. Like you, if everyone helps each other, I believe there won't be problems but more solutions before problems arise (we will have a choice of solutions at that time :D).
Well, nothing to comment, it was really wonderful. As I was browsing the sites, I came across a nice site like this and was able to meet wonderful people like you who are helping others.
I even need your help to grow in my career. Please help me out.
Thanks & Warm Regards,
Sunil
hrd.contact@gmail.com
From India, New Delhi
Acknowledge(0)Amend(0)
Hi Guys,
Very good morning. Here is the updated version of the tracker with additional features. We now support 9 departments. Each department can accommodate any number of employees. Each department has its own graphical output.
Hope this is useful to you. Last but not 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 with additional features. We now support 9 departments. Each department can accommodate any number of employees. Each department has its own graphical output.
Hope this is useful to you. Last but not least, thanks for the compliments, Sunil.
Regards, Kumar M
From India
Acknowledge(0)Amend(0)
Hi Kumar,
Thank you for your message. I noticed a few errors in your text that I have corrected below:
"One issue in the file is that you always need to enter a new record between rows 1-11 only and update the S.no column. I am currently working on fixing it. Until then, take care.
Regards,
Kumar M"
I hope this helps. Let me know if you need further assistance.
From India
Acknowledge(0)Amend(0)
Thank you for your message. I noticed a few errors in your text that I have corrected below:
"One issue in the file is that you always need to enter a new record between rows 1-11 only and update the S.no column. I am currently working on fixing it. Until then, take care.
Regards,
Kumar M"
I hope this helps. Let me know if you need further assistance.
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)
Hello, I am looking for help. I need a basic chart with a series to show client visits and a second series displaying how much was spent on a client visit.
I also need to show the months. Please and thanks for your help.
From Canada, Langley
Acknowledge(0)Amend(0)
I also need to show the months. Please and thanks for your help.
From Canada, Langley
Acknowledge(0)Amend(0)
Kim-Candy
Ask your IT department to show you how to use Excel or Google Sheets to develop your chart. You might also ask your manager to organize some spreadsheet training for you. That way, you will be able to construct a range of different charts for your HR functions.
From Australia, Melbourne
Acknowledge(0)Amend(0)
Ask your IT department to show you how to use Excel or Google Sheets to develop your chart. You might also ask your manager to organize some spreadsheet training for you. That way, you will be able to construct a range of different charts for your HR functions.
From Australia, Melbourne
Acknowledge(0)Amend(0)Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Employee Satisfaction analysis[1][1]. chr.xls
Employee Appraisal Form new.doc