Sorting the legend of a line graph

[#1]

Hello,

How can I sort just the legend of my line graph by highest value? I have two dimensions (Year and Value) and one expression. Right now the legend is sorted alphabetically but i would like it to be listed from highest value to lowest. Thank you

[#2]

Hi

You can do this by going to chart properties then the sort tab. In here:

-click on your 'Value' field

- in the sort by section on the right hand side tick 'experssion'

- in the expression area enter the same formula that you are using for the 'value' field.

- choose sort descending.

- ok

any problems just let me know.

dan