Stack Bar with multiple Columns on Dashboard
In this article we demonstrated how to create stack bar using three columns. The second column is the category that splits the stack.
So what if your data is not classified by a column. If you had different columns representing each stack, you can still create a stack bar.
Here is the Excel screenshot of some sample data. Each column represents the amount spend by a Person on different things such as measl,travel,gas,car and hotel. You want to see a stack bar for each person where each stack represents each column value.
You connect to this Excel file through InfoCaptor
Create a Dashboard and add the stacked bar chart.
Click Apply and you get the below stack bar
so there is no need for any special logic. You can do it with three columns or multiple columns