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.
Hi galvar1975 ,
Is the sort order related to the Prioridad column you show on the first image?
If yes you just need to sort the Tipo de Despacho by the Prioridad column and add the Tipo de Despacho to your legend.
However, in the chart, you show since you have negative values they will always go to the bottom of the visual because of their signal.
Regards,
MFelix
Thanks MFelix
Only one category has negative values (Intercambio), that´s why I want it in the bottom.
Sorting by column does not work.
Regards
Giovanni