Hello,
I use a linechart and a barchart on one sheet. The main dimension is time the second dimension is "Type".
I limit to show only 10 largest Values of the type dimension.
I would like to have a legend on each chart with exactly the same order of elements.
The problem is that the barchart legend seems to be ordered from bottom to top and the line chart from top to bottom.
When I order the Barchart by Text Z->A and the Linechart by Text A->Z, I get the same order of the dimension elements.
But while "Others" are on top in the barchart legend, they are on the bottom in the linechart legend.
Is there a way to set the position of the Others in legend separately from the general Sort option?
Something like: Others first/last.
Thanks for any tips!
