Legenda sorting with set analysis not working as expected
I created a stacked chard based on a three column dataset using the set analysis feature. However, no matter what option is tried, the legenda isn't sorted like the data.
As depicted in the screenshot below, we ordered the sets on the axis, the bars are stacked accordingly. However, the legenda is ordered some other way (random?).
Using reference coded for custom sorting, didn't help:
What's your advice?