Hi Exel Champions,
I am in a struggle at this....
I want my plotted chart to be dynamic (shrink and expand based on only the names that are added to my NEW EMPLOYEE sheet.
Issues with my plotted graph:
Help
Thanks
Shereen
I am in a struggle at this....
I want my plotted chart to be dynamic (shrink and expand based on only the names that are added to my NEW EMPLOYEE sheet.
Issues with my plotted graph:
- Currently: my graph plots the empty cell names and the COUNTA function is reading 7 columns. I want this graph to only show the names of the current employees SARAH, JIM, MARK, TIM.
- I am planning on locking the cells once I complete this project, and give access to the user to add/ delete data in the NEW EMPLOYEE sheet, such as a manager that uses it can add new employee (typically will add it in the next available new row., and add/delete title, and add/delete Hire date, and select the appropriate Manager from the list drop down.
- I am planning on also locking the SKILLS-MATRIX sheet and giving access to the user, in this case the manager to only made entries in the ACTUAL yellow highlighted filed. And if an employee leaves the company the values for those actuals must be deleted so that the graph doesn’t plot the old data.
Help
Thanks
Shereen