Creating an 'overflow' semicircle donut chart
I'm trying to create a semicircle donut chart in the dashboard to show how much the team overspent towards a budget.
For example, the budget is $100 per month but the team spent $150. Is there a way of creating an 'overflow' semicircle donut chart that shows the extra? Instead of showing a full semicircle donut chart for those more than 100%.
Attached is a sample for reference.
Help Article Resources
Check out the Formula Handbook template!