Help in producing employee capacity pie-chart

Thank you Riny_van_Eekelen . This looks like it would certainly do the trick. I was overcomplicating with the pie chart.

Could I ask, would it be possible to format the gradients to reflect the increase in workload 0-3 = Green gradient, 3.5-6 = amber gradient, 6.5-8.5 = red gradient, 9 = solid red? I attempted to do this in cell F5 of this https://myntuac-my.sharepoint.com/:x:/g/personal/stuart_samuels_ntu_ac_uk/EZae-qETVf1Lrf2hQnrjDGkBfz-vpBcft6CoXYrra47a_w?e=kHyxEF you sent, but it doesn't seem to have any effect. Would you be kind enough to advise?

Thanks again,

Stuart.