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 ?

Solution

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.

Comments

[cybernetic.nomad]

A screen cap of the table used to generate this chart would be useful to diagnose the problem

[Karima Touati]

@cybernetic.nomad I resolved the problem. It was not linked to the data table. I simply changed the place of the legend to right and then to left so I got the desired order.

[Karima Touati]

l tried that methode but it didn't worked. It was not linked to the data table as well. I simply changed the place of the legend to right and then to left so I got the desired order

[JounceCracklePop]

Both Left and Right had the reverse order for me, but changing it to Top and then manually moving & resizing it got it into to the correct order.