Dear Members,
I have an urgent requirement to create a chart for my management.
I have raw data which has the following values.
Column A - Name of Employees
Starting from Column B - Employee's respective utilization for each month i.e Jan, Feb, March and so on
Now I have been asked to prepare some graphs to show the consolidated utilization of the department month wise. Ok no problem, I have done that.
Tricky part is, I have also been asked to provide the number of active employees vs and their collective utilization for each month and I have not been able to figure out as to how to do it. What I have done in the sheet, is to insert another column and mention "Resigned or Working" for employees who do not have any utilization figures for 2/3 months (Assuming that these people have resigned) but I do not know how to put all this information together in graph. Please help.
I have attached a test sheet here for your reference.
PS - I apologize if I have put this thread in wrong section as I just joined the forum and have not gone through the rules. Please feel free to move it accordingly.
Bookmarks