Excel – How to reverse Excel legend order

chartsdata visualizationmicrosoft excelmicrosoft-excel-2016

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.

Image containing legend and bar chart, in which the order of the legend doesn't correspond to the order of the bars

How can I change the legend order or reverse it ?

Best Answer

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.

Related Question