Insert Icon to represent progress
- Thread starter jiajia97
- Start date
GraH - Guido
Well-Known Member
Conditional format - data bar perhaps?
Hi,
Thank you for your reply. I had managed to insert the icon using conditional format to present my KPIs progress. However, how to calculate the average values of the KPIs and present it using the a doughnut chart?
For example:
Green icon: x=100
Yellow icon: 50<x<100
Red icon: x<50
How can i write a coding so that I may calculate the values from the icon and create a doughnut chart to represent the progress in percentage? FYI, my KPIs might increase or decrease hence i need it to be flexible...
I hope the team may assist me on this matter. Thank you!
Thank you for your reply. I had managed to insert the icon using conditional format to present my KPIs progress. However, how to calculate the average values of the KPIs and present it using the a doughnut chart?
For example:
Green icon: x=100
Yellow icon: 50<x<100
Red icon: x<50
How can i write a coding so that I may calculate the values from the icon and create a doughnut chart to represent the progress in percentage? FYI, my KPIs might increase or decrease hence i need it to be flexible...
I hope the team may assist me on this matter. Thank you!
GraH - Guido
Well-Known Member
Behind the icon of the conditional formatting lays a formula. So I don't see the issue. Perhaps uploading an example with some fake data can help?
Simply averaging KPI results sounds really bad. I would go with a weighted normalized score.
Attached is an example to get the idea behind the technique. In your case there is a value to apply on the "icon" results, which is I assume a threshold. Se green might be a score of 5, yellow of 2 and red 1. Depending on the KPI this might be different as long as the max scores are always the same.
I don't have time left to quickly make such a version for you. I hope it can be an inspiration.
Simply averaging KPI results sounds really bad. I would go with a weighted normalized score.
Attached is an example to get the idea behind the technique. In your case there is a value to apply on the "icon" results, which is I assume a threshold. Se green might be a score of 5, yellow of 2 and red 1. Depending on the KPI this might be different as long as the max scores are always the same.
I don't have time left to quickly make such a version for you. I hope it can be an inspiration.
Last edited: