View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Series order conflicts with line order

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