Forum Discussion
Stacked Bar Chart Order
For a stacked bar chart it adds the lowest sort order item to the bottom unless it is negative but since only one category appears as negative and you want that at the bottom anyway that works out. Then we just set the order for the rest how you want them to stack in the chart.
We add a column to your priority table that we will use to set the order.
- Select [Tipo de Despacho]
- Click "Sort by Column"
- Click our order column
Now when you add [Tipo de Despacho] to the legend, add it from the 'Priority' table because that is the one we applied the sort order to. You will see that they stack from bottom to top based on the order we set.
MFelix wrote:Hi galvar1975 ,
Is your legend based on the first table in the image or the second?
Regards,
MFelix
Hello MFelix
I tried with both of them. The result is remain the same.
Regards
Giovanni
For a stacked bar chart it adds the lowest sort order item to the bottom unless it is negative but since only one category appears as negative and you want that at the bottom anyway that works out. Then we just set the order for the rest how you want them to stack in the chart.
We add a column to your priority table that we will use to set the order.
- Select [Tipo de Despacho]
- Click "Sort by Column"
- Click our order column
Now when you add [Tipo de Despacho] to the legend, add it from the 'Priority' table because that is the one we applied the sort order to. You will see that they stack from bottom to top based on the order we set.