How to create Stacked bar chart using different columns?

[Kritika_Dhanbhar]

I am trying to create a stacked bar chart that shows the distribution of expenses (Over budget amount,Under budget amount,team costs and expenses).I have different columns in my datasource for team costs,expenses,budget and Remaining budget.Will I have to reorganize my data set and add a column that categories various values as teamcosts or expenses to get the stacked bar chart?My dataset and objective is:

Is there any other workaround?

Thankyou so much!

[Kritika_Dhanbhar · Accepted solution]

I found the solution!

I did this by Pivoting the table in data set like:

I have aggregated all the expenses,teamCosts,Remaining budget values for each client by pivoting it.And then transformed it as shown.

Hope this helps someone. 🙂