Order of items in legend, stavked bar chart

I often do a figure like the attached example: a horizontal stacked bar
chart with a legend.
The problem is that the order of the legend is always the opposite of the
order in which the actual stacked bar chart segments appear. I.e. the
stacked bar chart goes: violet, red, yellow. But the legend goes: yellow,
red, violet.
Therefore, to fix that, is there any way how I can control the order of the
legend?
Manually adjusting this in the resulting PDF/PNG is very tedious.

Thank you,
Anton

==
Gnumeric 1.12.28

_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list