Goal: control the layering of each data series from front to back on a line graph.

Issue: Moving the data series up or down the data series list does not seem to affect the layering position.  The graph has many data series both line and non-line.

 

 

Goal: control the layering of each data series from front to back on a line graph.

Issue: Moving the data series up or down the data series list does not seem to affect the layering position.  The graph has many data series both line and non-line.

 

 

There are certain cases where Excel will not let you change the layering.  One of them is when there are different types of series in the same chart.  For example, with a Line and a Column series, the line is always in front of the column.

Another case is when there are series on the secondary and the primary axis.  For example, a column chart on the secondary axis is always shown in front of a column chart on the primary axis.

Hi Tushar,

I have a chart with a line and a column chart, so I see that bringing column chart to front is impossible. However, my line chart is just a horizontal line, so I can easily replace it with just a line. However, I cannot still figure out how to either bring that line to the back or bring the column chart to the front.

Thank you

You can right click the line you created and select 'Send to back'