charts: move graphics plot to front

nick323f

New Member
Joined
Jul 8, 2014
Messages
43
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
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

nick323f

New Member
Joined
Jul 8, 2014
Messages
43
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 ?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,364
Messages
5,595,722
Members
414,013
Latest member
tnobbs

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top