Forum Discussion

Copper Contributor

Apr 06, 2022

Help in producing employee capacity pie-chart

Hi. I'd like guidance on creating a data sheet with linked pie-charts that reflect employee capacity, to help me see at a glance who has/hasn't capacity to take on further projects and who is at m...

Charting

excel

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Apr 07, 2022

stusam Perhaps you want to consider using Conditional Formatting (CF), rather than pie charts. Especially because you want colors to change based on the numbers in the chart.

I have attached a file with just two possible CF rules, and there are many more.

stusam.xlsx10 KB

stusam
Copper Contributor
Apr 07, 2022
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.
- Riny_van_Eekelen
  Platinum Contributor
  Apr 07, 2022
  stusam I'm afraid it doesn't work like that. You can only have one data bar per cell, as far as I understand.