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
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
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
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
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
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
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
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
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
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
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
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
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
Regards
Kumar M
From India
Hey Friends, I hav got good stuff in this site. Both excel sheets were excellent!! Good work. Regards Manisha
From India, Mumbai
From India, Mumbai
Much Appreciated ! good work, it helped a bunch, sampled your idea and used it to make one for my work ! regards
From Pakistan, Lahore
From Pakistan, Lahore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Create bell curve in XL.doc
Create Your Own face.xls