How to reorder chart series in Excel?
The inserted data series of a chart are in the same order as the order of the original data based on column in default. Now this tutorial tell you how to reorder the chart series in Excel.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To reorder chart series in Excel, you need to go to Select Data dialog.
1. Right click at the chart, and click Select Data in the context menu. See screenshot:
2. In the Select Data dialog, select one series in the Legend Entries (Series) list box, and click the Move up or Move down arrows to move the series to meet you need, then reorder them one by one.
3. Click OK to close dialog. Now you can see the chart series is reordered.