Line chart - Custom Legend order

[#1]

Hello,

I have a line chart where the legend is in an order which I would want to change.

If you notice though Stream 2 (orange line) is on the top whereas Stream 1 (blue) is way below.

I want to sort the legend based on the order in which the chart appears

So my legend would be

Stream 2

Stream 3

Stream 6

Stream 5

Stream 4

Stream 1

How do I achieve this ?

Thanks,

[#2]

Thanks Gysbert. That's a very interesting function. Wonder why it's not in the search result of functions in help system.

[Gysbert_Wassenaar]

No idea. If I search the help file I can find it just fine.

[#4]

Must be user error on my part then.

Thanks

[#5]

For this,

If you want static change in your legend then you can change order in expression so accordingly that will change order in chart and make color for line.

But for dynamic need to think.