Trying to alter the order of my legend in a report

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

Please someone explain to me how I can alter the order of the items in my
legend in a report. It currently goes in alphabetical order, but I would like
it to be ordered by biggest piece of the pie on the chart/number. Thanks
 
Could you not use a translation table that has two fields - the text and a
number - with the number order that which you want the text.
Then in your query join on the text fields and sort on the number but not
display.
 
Back
Top