Sorting 100% stacked bar chart by %values

[MaishaA]

Hi, 

Is there a way to sort a 100% stacked bar chart by percentage values, rather than the data value? 

Thank you,

Maisha

[AndrewSEA]

You can sort any 100% stacked bar chart any way you want by adding a new value that holds the sort values you want to the stack and divide by 100000 so it's too small to be visible.  Then you can clear the label and make the color the same as the background so it's invisible.

[v-piga-msft]

Hi @MaishaA，

You could have a reference of this similar thread.

If you need additional help please share some data sample and expected output.

Best Regards,

Cherry