jitha
1

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
kumar.exe
8

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
Attached Files (Download Requires Membership)
File Type: xls tracker_578.xls (19.0 KB, 2309 views)

jitha
1

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

Attached Files (Download Requires Membership)
File Type: xls example_graphs_361.xls (22.0 KB, 1308 views)

sunilkumar.lawrence
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
kumar.exe
8

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
Attached Files (Download Requires Membership)
File Type: xls tracker_updated_506.xls (47.5 KB, 1360 views)

kumar.exe
8

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
Manisha_21
Hey Friends, I hav got good stuff in this site. Both excel sheets were excellent!! Good work. Regards Manisha
From India, Mumbai
Umer K
Much Appreciated ! good work, it helped a bunch, sampled your idea and used it to make one for my work ! regards
From Pakistan, Lahore
kushkush001@hotmail.com
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

From Somalia, undefined
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.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.