Need help in Visualizing Employee Data

[dvm49]

I have the same set of Employees working in two different Projects (i.e Project-1 and Project-2) and in Each Project the particular employee might have contributed different working hours.. I would like somehow visualize this data and see in which project the employee has contributed more. I have attached an sample data, it would be great if someone can guide on how this data can be represented visually. Thanks a lot in advance.

 

[AliGW]

Maybe combine the tables and create a stacked bar chart.

 

[dvm49]

Thank you so much @AliGW Is there a way that I can sort the stacked bar chart based on the duration in descending order?

 

[vletm]

dvm49​

You could sort it many ways with Your original data too.


or something like below (right side file)