How to create Stacked bar chart using different columns?

Kritika_Dhanbhar — Tue, 21 Feb 2023 13:00:46 GMT

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!

Re: How to create Stacked bar chart using different columns?

Kritika_Dhanbhar — Tue, 21 Feb 2023 18:58:11 GMT

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. 🙂

topic Re: How to create Stacked bar chart using different columns? in App Development

How to create Stacked bar chart using different columns?

Re: How to create Stacked bar chart using different columns?