How to sort the chart values?

[Toybits]

I have a chart that always show alphabetically arranged under Category Name column. Is there a way to set the sort in the [Amount] column in descending order?

Thanks a lot!

[jaichith]

Use New chart editor, but I may be unstable in many cases. 

[Def]

Not a great answer. 
Is there a more robust way of doing it ?

[Steve]

Graphs and charts are not well supported. Consider using QuickCharts.

[Koichi_Tsuji]

Look into Looker studio as well. 

the development of new AppSheet chat view is abandoned by Google teams so no hope for betterment towards the future.