Hi All,

I have a xy-scatter plot that has 4 different series of x, y data.
The 4 series, two series (1 and 2) use the primary axis and two series (3 and 4) use the secondary axis because of range differences in the y data. Series 1 and 3 are data points from an experiment. Series 2 and 4 are calculated curves and plotted as smooth lines Right now the calculated curves are behind the data points and can't see the lines.



Here is what the XY Scatter Plot looks like in Excel 2010:Attachment 269433

I can not sort the plot order of the series. I would like the series to be plotted Series 1, Series 2, Series 3 then Series 4. Excel 2010 does the plot order as Series 2, Series 4, Series 1 then Series 3. It does not matter what order I put the order in using Excel Help:

Change the plotting order of data series in a chart
1.Click the chart for which you want to change the plotting order of data series.
This displays the Chart Tools, adding the Design, Layout, and Format tabs.

1.On the Design tab, in the Data group, click Select Data.


1.In the Select Data Source dialog box, in the Legend Entries (Series) box, click the data series for which you want to change the order.
2.Click Move Up or Move Down to move the data series to the position that you want.


THIS DOES NOT DO ANYTHING.
I never had an issue in Excel 2003
Does anyone know how to resolve this?


Here is a funny/weird thing: When I copy the above chart from Excel and paste it in a Power Point Presentation the calculated line for the data represented with squares appear above the data the way I would like it to be display.

Attachment 269435

Does anyone know how the sort order works in Excel 2010?