Sort data table legend in reverse order of vertical axis

[Robertjb1]

Hi. I respectfully request assistance. I have created a bar chart that has a vertical axis with a two column source sorted alphabetically. One is the labels and one is the values that determine how long the bar is...easy so far... When I sort the source, the legend at the bottom of the chart sorts alphabetically from right to left not left to right, as desired. The legend at the bottom of the chart always sorts in the reverse of the axis. How do I get the bottom to sort from left to right with the vertical axis sorting from top to bottom? I've attached a picture showing the vertical axis sorted from top to bottom. Thanks.

[Andy Pope]

You can't.

The bar chart axis goes from bottom to top.
The table goes from left to right.

You can almost fake it by using 2 series. The primary axis gives the data table the correct order. The secondary axis can be used for axis labeling. The major drawback is that both series will appear in the data table and you will need to mask this in some way.