Help Visualizing Budgets Expenditures


I have a table where each record represents a department with a unique budget line. So my columns are total budget, expenditures, and then a simple calculated field of what is left in the budget.

I would like to utilize a Donut Chart to visualize what has been spent and what is left in the budget for each record. However, I can’t seem to conceptualize how I would execute this in Airtable. As I understand it, the Airtable chart can only view the breakdown of the

It seems to me that I would need to pivot the entire table so that my columns now represents the department. Is there an easy way to do this?