How to reverse Excel legend order?

Question

I have an Excel graph (a stacked bar chart) where years are on the x-axis.

The problem is that the order of the legend labels doesn't fit with the order of the values in the bars as shown in the picture below.

How can I change the legend order or reverse it ?

Answer 1

As Karima pointed out : the solution that works is simple, although not intuitive: Change the place of the legend to right and then to left (or reverse) and you get the desired order.

Answer 2

This may help:

1. Right-click on the graph
2. Click on "Select data..."
3. Use the arrows above the series list. Note : it will move the graph's bars as well.

Here's a screenshot to explain. Let us know how it goes.