Posted By: Anonymous
How does one reorder series used to create a chart in Excel?
For example, I go to the chart, right click > Select Data. In the left column I see series 1, series 2, to series n.
Say, I want to move series 3 after series 4, can it be done from chart view? I don’t want to move the data cells in the worksheet.
I’m using Excel 2011 (mac OS X).
Select a series and look in the formula bar. The last argument is the plot order of the series. You can edit this formula just like any other, right in the formula bar.
For example, select series 4, then change the 4 to a 3.