Ability to sort the individual stacks within a stacked bar chart
There is a way to sort the overall bars when multiple bars are created in a chat of this type (top right corner), but the ability to decide which category stack is displayed on top and which one at the bottom of the single columns seems to be missing. The workaround I found (creating and connecting a new column to the data with artificially spaced names, and then using this new column in the legend field of the chart) looks overly complicated.
This is something that's easy to do in Excel, Pivot Table and Power Pivot, so the ability to sort a stacked bar chart by the total value is sorely missed.
Rodolfo Ramirez commented
Secomd this idea. I have a stacked bar chart that orders the biggest 2 and the third one (smallest) remains in the middle.