Cannot Display Chart report in descending order

Question

Can someone share how to display a Chart report with Y count values in descending order (highest on left)?

The data table is already sorted in descending order for my discrete numerical (ordinal) data, and I modified this column properties by clicking 'reverse" in the "Value Ordering" window. Still the Chart displays the data in alphabatical order instead of numeric descending order.

Thanks!

chungwei · Answer

Actually, if you have a simple chart, like one categorical column that you want the count of, Pareto will do it. Pareto always display the count in descending order.

chungwei · Answer

The bars of the chart (assuming bar chart is requested) will be shown in the order of your X column, not the order of the count values. Chart does not have an option to display bars in order of count values.

chungwei · Answer

I tried doing subset on a data table with a column XXX that has value ordering assigned to it, and the column XXX kept its value ordering property in the subset. When I did a chart with XXX assigned as X, the chart shows the bar in the order as specified in the Value Ordering.
So I am curious as to how you assign and use the Value Ordering property that failed to work.