AssetRecovery
Programmer
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.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Chart legend sort order
- Thread starter AssetRecovery
- Start date
- Status
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
(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
- Thread starter
- #4
AssetRecovery
Programmer
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?
- Status
Similar threads
- Locked
- Question