0

I'm trying to make a simple scatter plot in Excel. One variable are field measures of river flow. The other one is the fitted rating curve (done externally). I draw the field measures as marked scatter plot. For the rating curve I created a column with the water level at each centimeter and the respective water flow calculated with the curve equation. With this pair (water level, water flow) I have added a second series and changed from marked scatter to straight lined scatter plot.

The problem is that I need to see the rating curve over the measures plot. I had changed the plot order but didn't work. The marked plot is always over the lined one.

Any suggestion!?

Scatter (marked and straight lined) plots

M--
  • 25,431
  • 8
  • 61
  • 93
Angelo Breda
  • 13
  • 2
  • Take a look [here](http://stackoverflow.com/questions/5161284/reordering-chart-data-series-in-excel) – gtwebb Apr 29 '16 at 21:36

1 Answers1

0

I have not had success with changing series order causing scatter data to appear behind a line. Even though the order of the Legend will change, the plot order does not appear to be affected.

In order to get your line to appear in front of the scatter data, you will need to put the line on the Secondary Axis, then make sure your min/max values for the secondary axis are the same as the primary.

If you don't want to see the secondary axis set the Label Position to None.

enter image description here

OldUgly
  • 2,129
  • 3
  • 13
  • 21