8

I have a excel graph with two lines using the primary axis and a column using the secondary axis. The legend currently lists the column first followed by the two lines. I would like to list the lines first in the legend since the axis they are referring to are on the left side of the graph. Is there any way I can change the legend order?

Starfish
  • 1,017
drv82
  • 91
  • I thought that the legend always list all entries for primary axis first even if the series order is different. maybe try replotting. – user70926 Jun 26 '15 at 07:01
  • I'm having exactly the same issue, using Excel for Mac with office 365. As soon as I changed the plot on the secondary chart to 'column', the order changes and changing the order in the 'Select data' didn't change anything. The question has been locked so I can't actually provide an answer but I'll add another comment below with the steps I found to fix it. – getting-there May 01 '18 at 02:49
  • Set up chart as you described - line and column chart with column on secondary axis
  • Used "select data" dialogue to change order so column chart is first in the order - this won't change the legend, but just the order in the 'select data' dialogue
  • Change column chart back to line chart (still on secondary axis)
  • Change order back so that new line chart (on 2nd axis) is now second in the order
  • Change new line chart back to column chart type.

    • When I did this, the column chart stayed second in the order.

    – getting-there May 01 '18 at 02:49