Re-order clustered column chart

I have a table with the following columns: - Work opportunity type (of which the values can be 'Intro', 'Scoping', 'Lost', and 'Awarded'). - Value £ (decimal number) I can create a clustered column chart to show the data, but I want to re-order to series manually. All I can do is sort by 'Value £', or just alphabetically by 'Work Opportunity Type'. Is there a way I can manually re-order a clustered column chart? Thanks in advance for any ideas...