This question is almost stupid but, since I'm working late at night in this part of the world, I'm too confused that I can't find the easiest command.
I have a scattered graphs with many series. Some data of, say, series A cover data of series B. However I would like B to be in front.
Is there a way to accomplish this as in powerpoint? I'm using excel 2011 on MacOS Mavericks.
Thanks!
p.s. here is what I get from "select data source"
2 Answers
Select the chart and edit the data source. 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 a series and click the up or down arrows to move its position.
In the screenshot you can see the Series order for the lower chart. Series1 is listed after Series2 and will be plotted on top
Edit: Apparently the option to re-order the series does not exist in the respective dialog on Excel for Mac. In this case, edit the formula for the data series in the formula bar.
Select the data series in the chart and look at the formula bar. You will see something like
=SERIES(Sheet1!$C$1,Sheet1!$A$2:$A$8,Sheet1!$C$2:$C$8,2)The last number in this formula is the order of the series. You can edit and change it in the formula bar. The lowest number series will be plotted behind higher number series.
Before: the orange series has the number 2 and is plotted on top of the blue series (which has the number 1)
After: the orange series has the number 1 is plotted behind the blue series (which now has the number 2)
So, to bring a series to the front, make sure that its order number is the highest of the series in the chart.
5Unfortunately does not work for Combo Charts - when you combine e.g. stacked colums and a line, the line will always be on top no matter what you do. The only way I've found is to manually overlay two charts, which you can then arrange easily with 'bring forward' etc. Lots of manual adjusting until the overlay fits however...
2
