I have spreadsheet that contain training information for thousands of folks who have training assigned to them. Folks are scattered throughout the nation and have been assigned to one of three manager's who track training status. Is there a way of visualizing the complete vs. incomplete training records in a line-chart listing the three managers? This information will have to be updated every two weeks, therefore adding to the line-chart.
Visualization of content
- Thread starter cowboyjoe
- Start date
Here's how I would do it:
X-axis is your time scale. As time goes on and you get more data points, line will travel to the right.
Y-axis I'd make a percentage scale from 0 - 100%.
Then, make 1 series for each manager, plotting % of employees you are complete.
Intent of this chart would be to compare the managers/groups as a whole to each other.
To generate data, need to know # of people for each manager that are complete vs total, so something like:
=SUMPRODUCT(--(ListOfManagers=Manager1),--(StatusList="Complete"))/COUNTIF(ListOfManagers,Manager1)
X-axis is your time scale. As time goes on and you get more data points, line will travel to the right.
Y-axis I'd make a percentage scale from 0 - 100%.
Then, make 1 series for each manager, plotting % of employees you are complete.
Intent of this chart would be to compare the managers/groups as a whole to each other.
To generate data, need to know # of people for each manager that are complete vs total, so something like:
=SUMPRODUCT(--(ListOfManagers=Manager1),--(StatusList="Complete"))/COUNTIF(ListOfManagers,Manager1)