I have a problem with preparing report from data that are stored like in attached file. I want to prepare report or (even better) chart showing how number of engaged employees changed within time for each project.
The best option would be to prepare line chart consisting of
Horizontal axis - Time
Vertical axis - Number of employees
Colours of lines - each colour of line assigned to one project (ProjectA, ProjectB, ProjectC etc.)
But I would be extremely grateful for any other hints too.