You can do this by going to chart properties then the sort tab. In here:
-click on your 'Value' field
- in the sort by section on the right hand side tick 'experssion'
- in the expression area enter the same formula that you are using for the 'value' field.
- choose sort descending.
any problems just let me know.