Plotting a series on the secondary axis also changes its place in the
legend.

You could plot the series twice, format both the same in the chart, and then
delete the legend entry which you don't want. To delete a single legend
entry, select the legend, then click on the legend entry's label, and press
delete.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Andy Pope" wrote in message
...
Hi,

Perhaps you could use the secondary axis, which will plot lines in front
of the primary axis series.
Add a new series based on the same cells and set it to the secondary axis.
That should sort the obstruction. You will then need to remove the
addition legend entry, see here for details of how to do that.
http://www.andypope.info/charts/deletelegendentry.htm

Cheers
Andy

Cowtoon wrote:
I've set my series in the order that I want, however, it conflicts with
the visual layout of the lines. One data line (less important) visually
obstructs another line in the chart. Is there a way to change the layout
order (without changing the series order), i.e., forcing it "back" or
"behind" another line.

Thanks. Diana

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info