i would like your assistance on the attached excel
1. lets say i have three employees, which i need to track their utilization , how can i make it as a graph ?i tried to do it in pivot , as i couldnt make it . any advise .
2. As you can see , i have provided status as open or closed , how can i change the entire row (where the text is present ) to be changed to red or green , when status is kept closed .
Appreciate your support.