The lowest number series will be plotted behind higher number series.īefore: the orange series has the number 2 and is plotted on top of the blue series (which has the number 1)Īfter: the orange series has the number 1 is plotted behind the blue series (which now has the number 2) You can edit and change it in the formula bar. The last number in this formula is the order of the series. Select the data series in the chart and look at the formula bar. In this case, edit the formula for the data series in the formula bar. Series1 is listed after Series2 and will be plotted on topĮdit: Apparently the option to re-order the series does not exist in the respective dialog on Excel for Mac. In the screenshot you can see the Series order for the lower chart. Select a series and click the up or down arrows to move its position. The order of the series in the left hand side of the dialog will determine which series show in front of others, as long as they are all plotted on the same axis. Select the chart and edit the data source.
