How to Change the Order of the Legend in an Excel Graph

1. Locate the chart data in the Excel spreadsheet. To locate the applicable data, click on the graph: the data will be surrounded on the worksheet by a blue box.
2. Copy the data, then paste it to a clear area on your workbook. Alternatively, paste it into a new worksheet.
3. Change the data into the order you want it to appear on the graph then copy and paste the columns.
4. Copy and paste the new data order back into the original spot on the workbook.