Reordering Chart Data Series [closed]

Question

Closed. This question is off-topic. It is not currently accepting answers.

---

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 2 years ago.

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).

Answer 1

Excel 2010 - if you're looking to reorder the series on a pivot chart:

• go to your underlying pivot table
• right-click on one of the Column Labels for the series you're looking to adjust (Note: you need to click on one of the series headings (i.e. 'Saturday' or 'Sunday' in the example shown below) not the 'Column Labels' text itself)
• in the pop-up menu, hover over 'Move' and then select an option from the resulting sub-menu to reposition the series variable.
• your pivot chart will update itself accordingly

Answer 2

To change the sequence of a series in Excel 2010:

• Select (click on) any data series and click the "Design" tab in the "Chart Tools" group.
• Click "Select Data" in the "Data" group and in the pop-up window, highlight the series to be moved.
• Click the up or down triangle at the top of the left hand box labeled "Legend Entries" (Series).

Answer 3

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.