Legend sorting on a diverging bar chart doesn't match

[Anonymous]

I've created a diverging bar chart using a 100% stacked bar chart but the sorting of each individual legend item does not match the legend as shown in the image below

  What I want to accomplish is to have the Answer 0 legend items appear on the far left, followed by Answer 1, followed by Answer 2, etc... In other words, the order of the items for the charts elements should match the legend.  The Answer Text column is being sorted by SortOrder which is an integer.  I'm thinking this has something to do with the negative x-axis.  Any help would be greatly appreciated

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

---

@Anonymous wrote:

I've created a diverging bar chart using a 100% stacked bar chart but the sorting of each individual legend item does not match the legend as shown in the image below

  What I want to accomplish is to have the Answer 0 legend items appear on the far left, followed by Answer 1, followed by Answer 2, etc... In other words, the order of the items for the charts elements should match the legend.  The Answer Text column is being sorted by SortOrder which is an integer.  I'm thinking this has something to do with the negative x-axis.  Any help would be greatly appreciated

---

Yes, as you said, it's design. The negative axis is sorted in the opposite order. I believe you can understand this principle.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.