Forum Discussion
How to re-order data series in a chart with multiple vertical axes
I have a combo chart that is all just lines plotted (not 3D or anything special), but I have two vertical axes. There are three data series on the primary axis and two on the secondary. No matter how I re-order them, for some reason the two series on the secondary axis always stay on top. This didn't happen until I started using Office 365, seemed to work file when these spreadsheets were still in the older versions of office (2013 and 2016). I just need for the re-order to work properly so I don't have to go in and switch them all over, because the only way I can find to fix this is by switching the two vertical axes.
1 Reply
- I've been working with Excel charts a lot and just tried to find a solution for your issue. I also don't see a way to do that. Since you already figures out the workaround, I would say that you should go for it
