In excel 2010 I have a trend line chart showing 13 lines of data. Is there a way to show the legend data in the order of the latest results? I cannot change the order of the source data.

Thanks for any help.