Hi MashZone Team

 

I have follwoing table structure in excel spreadsheet.

Name   laborcategory   projectname hours deptname

----------------------------------------------

john      fulltime               project1        8          dept1

john      fulltime               project2       10         dept1

 

Mark    contractor          project1        8          dept1

Mark    contractor          project2       10         dept1

 

Paul      fulltime               project1        8          dept1

Paul      fulltime               project2       10         dept1

I have been working on different charts on this data but there is one need where i need to show %contractor vs % fulltime for deptment in PieChart. For this example , it would be 

2 full time and 3 contracts in dept 1 (66% FTE vs 33% Contractor). How do i do it?

Please help.

 

Thanks.

 

 or register to reply.

Notify Moderator