Legend sort order on Bar chart

[orangebloss]

Is there a way to force the legend sort order on a bar chart? 

I have the chart below which plots effort across weeks, I want the legend to list the projects in the order that they start / appear on the chart. I have a field called 'Resource Start' which I though I might be able to order them in , but while it orders the blocks on the bars it doesn't affect the legend at all, which remains alphanumerical.

In the example below the lilac colour needs to be the 6th entry in the legend as it starts after all the others. 

[Chanty4u]

Try to create calculated dimension or master dimension 

Dual([Project Name], Min([Resource Start]))

Sort by Numeric Value by asc order 

[orangebloss]

Thanks - When I create the Master Dimension as you've suggested the chart shows 'Invalid Dimension'