Chart legend sort order

[AssetRecovery]

Is there a way to control the sort order of a legend for a chart? Mine always sort alphabeticaly by the group names and I'd like to sort by the highest to lowest values.

 

[Madawc]

I don't use charts. But I often use a one-letter prefix to put group names in the order I want. You might say
(a) Incomplete
(b) Complete
(c) Cancelled

For a report group, you could also show a trimmed version of the name. If it were twenty character field, you'd set up @Disp_Name with Right(group-name, 16).

How this relates to charts, you'll need to work out.

Madawc Williams
East Anglia, Great Britain

 

[lbass]

In the chart expert, using the advanced layout, select the "on change of" field, select topN, and choose "All", your summary field, and sort descending.

-LB

 

[AssetRecovery]

I did this and it sorted by the count column but now I have lost my drill down ability. I was able to click on the different pie chart segments and the data in my group header would change according to that data slice. This was a nice feature. I change my chart back to group instead of advanced and the ability to drill down came back. Is there a way to have both?