I’m trying to create a chart to display utilization of a budget. Not picky on the style - could be pie, battery, or stacked. However, I can’t figure out how to create a chart that shows portions of a fixed total amount/percentage.
I have a status column for the status of the item and a numbers column for the amount. I’d like a chart that shows, for example, a total budget of $100 with $20 spent on status A, $10 spent on status B. This should show a third slice of the pie with $70 unspent, but I can only get the widget to generate a chart that shows the two slices combining for a total of $30.
This is a super basic function in something like excel but seemingly impossible in monday?
