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
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