Ask Your Question
0

chart legend suddenly reversed

asked 2016-10-12 20:49:06 +0100

matej gravatar image

updated 2016-10-12 20:51:23 +0100

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-10-12 23:47:30 +0100

mark_t gravatar image

updated 2016-10-12 23:49:17 +0100

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.

edit flag offensive delete link more

Comments

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?

matej gravatar imagematej ( 2016-10-13 18:20:24 +0100 )edit

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.

mark_t gravatar imagemark_t ( 2016-10-13 19:24:02 +0100 )edit

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?

Jethuth Cwithe gravatar imageJethuth Cwithe ( 2017-10-18 00:03:30 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-10-12 20:49:06 +0100

Seen: 331 times

Last updated: Oct 12 '16