Sorting the legend in a stacked bar chart

[Susann_Ullrich]

Hello all,

I have trouble with sorting the legend of a stacked bar chart. Basically I want to sort the categories ascending. However 2) and 4) just keep stuck at the bottom, whatever I try. I guess this is because there are no values for 2) and 4) in the first year of the data set.

Is there any way to achieve the correct sort order with keeping the order of the years?

Thank you.

[SerhanKaraer]

Hello Su,

I think sorting menu of the chart options allows sorting of the bar values, at least in November 2019 version.

[Susann_Ullrich]

Hello,

I already changed the sorting orders in the menu. That doesn't help. Also the creation of dual-values does not solve my problem.

I think it is really connected to not having values for every category for the first year. Still looking for a way to fix this though.