Forum Discussion
Solved
Stacked Bar Chart Order
Hi everyone: I need to sort the legend of a bar chart in a given order. (Below you can see the chart) I need - for example- all black data on the bottom, all yellow data stacked over the blac...
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.
