How to reorder legend entries?

I realise this is old, but in case anyone searching for an answer finds it, you can in fact re-order the legend. Just click on the actual line in the graph (you have to click twice: once to select the graph and a second time to select the line). Make sure you click on one of the data points. Once you've done it, you will see it looks similar to my screenshot below.

Select the "Format" menu, and then select the "Order" drop down menu (second picture, above). You can now reposition the currently highlighted line within the legend. Do this for every line until the legend looks how you want it to. Note, if the Value and Data boxes are blank, then click on "Style" and then "Series" again so that the name of the line you are changing shows in those boxes as shown above.

Hi Nevin,

I can't find a way to re-order a legend.

When all else fails, cheat 😉.

Use Screen Shots of each legend entry and move them into the order you want.

Take a Screen shot of each legend entry and Menu > Insert > Choose...

Navigate to the desktop, select a Screen Shot and click on Choose. It will appear on the canvas.

Align the Screen Shots, select them all

and Menu > Arrange > Group

Hide the default legend:

Click on the line chart and Format Panel > Chart > Chart Options > untick Legend.

Happy Numbering!

Regards,

Ian.

You could add a table that figures out the max. and reorders itself like this:

And this:

Then you can hide the charts legend:

In the large table ("Table 1-1") the top row contains the average

In the small table

A1=LARGE('Table 1-1'::$1:$1, ROW())

this means... select cell A1, then type (or copy and paste from here) the formula:

=LARGE('Table 1-1'::$1:$1, ROW())

B1="◦"&OFFSET('Table 1-1'::$A$2,0, MATCH(A1,'Table 1-1'::$1:$1,0)−1)

now select cells A1 and B1, copy

select from Cell A1 to the B3 (or how ever many rows you need), paste

I hid column A

now select column and use conditional formatting to make the color match the series in the chart:

Hi Goshdarnit,

Thank you. I always wondered what the Order pop-up menu was for!

Regards,

Ian.