Reordering Chart Data Series

excel charts excel-2011
KM. picture KM. · Mar 1, 2011 · Viewed 388.3k times · Source

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

Jon Peltier picture Jon Peltier · Mar 9, 2011

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.

Related questions

How to apply a saved chart template to an existing chart?

I recently created a custom contour chart in excel to display my data colored with a heat-map color mapping. I'm using a Excel 2011 on a Mac. I can't find a way to reuse the saved template. The help instructs me …

Read More
Swap x and y axis without manually swapping values

So I have a set of data that has conditional formatting. Basically it's a set of photometric measurements of stars that I want to put on a chart with different colors for stars in different ranges of Color Index (basically …

Read More
How can I color dots in a xy scatterplot according to column value?

Consider the following worksheet: A B C D 1 COMPANY XVALUE YVALUE GROUP 2 Apple 45 35 red 3 Xerox 45 38 red 4 KMart 63 50 orange 5 Exxon 53 59 green I have used the scatterplot function in Excel to create the following chart: However, each point in the chart has …

Read More