Just by changing the shape of a chart Legend, it suddenly became reversed in my favorite Calc spreadsheet. Is there a way to reverse it back to the original order?
legend reversed ods
Plot order is not reversed, you just have the y-axis positioned at the right of the x axis, unless of course you want the data plot order reversed.
Double click the chart to get it into edit mode. Select the y-axis. Right click and Format axis. Then on the Positioning tab, either select cross other axis at Category, select 2010, Or select cross other axis at start, and then click OK.
If you do want to reverse the plot order, select the x-axis. Right click and Format axis. Then on the Scale tab select Reverse direction.
Thanks for your answer @mark_t but the axes are just as I want them. The trouble is in the Legend, which is reversed.
I figured out that when I re-set the Legend using right click → Format Legend… → Position → Top, the order is just as it should be. But if I change either the size or position of the Legend, the order gets reversed. A bug possibly?
Yes I think you found a strange bug. Set to top or bottom position the legend is sorted in the order of the series in the Data ranges. Setting left or Right, or any manual change to position or size and the legend is in reverse order of the series.
Yes, this is a bug, as I have now confirmed myself. If you change the Legend position, the order of the Legend changes. How can this be reported?