Changing the order of graphs in 2010

Afternoon,

I have a table with all my data in, which I want to keep in the order and layout it is in. The table then generates graphs on the next sheet.

Is there any way to rearrange the order of the bars on the graph, so instead of the bars running in the order of the table on the previous sheet, I could order them will the highest, or lowest, figure first?

Thanks for any help you can give.

Data within the chart is not sortable.

You can manually change the plot order of the series. Use the Select data dialog > up/down arrows to change the order.