charts: move graphics plot to front

[nick323f]

Hi Guys,

Happy new year all.

Im using Excel 2016. I have a scatter chart with two lots of data, one on the primary axis and one on the secondary axis.
excel has put the plot for the secondary axis on top of the plot for the primary axis. I want to reverse this?

I have tried changing the order in the series
i.e. the "1" at the end of this section
=SERIES("Current Consumption",Sheet1!$H$2:$H$1199,Sheet1!$K$2:$K$1192,1)

this changes the order in the legend but not the overlay of the graphics.

Any one know how to bring the plot itself to be on top of the other?

thanks
Nick

 

[nick323f]

ok I found a solution. the solution was to reverse which plot was on the primary axis and which was on the secondary axis.
it is a disappointing solution. it meant I have to reformate all the axis and some other notes on the chart.

I would love to know a better solution ?