Sorting in stacked chart for value the individual series

[JakSrampota]

When having a stacked bar in pivot chart, I would like to sort the value from largest to smallest for the Legend (series) categories. How? 

Now, I can do it only for one series. 

[#2]

Hi @JakSrampota 

Hope you are doing well. I try to cover your use case. Image is attached hope this meet the requirement.

I create this chart for Microsoft Excel & Office 365.

And if you are comfortable with Google Sheets, you can find here.

Thanks