none
Excel 2010: Graph: Bring Series to Front of Graph

    Question

  • 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.

     

     

    Sunday, January 15, 2012 12:50 PM

Answers

  • 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.


    Tushar Mehta (Technology and Operations Consulting)
    www.tushar-mehta.com (Excel and PowerPoint add-ins and tutorials)
    Microsoft MVP Excel 2000-Present
    Sunday, January 15, 2012 7:05 PM

All replies

  • 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.


    Tushar Mehta (Technology and Operations Consulting)
    www.tushar-mehta.com (Excel and PowerPoint add-ins and tutorials)
    Microsoft MVP Excel 2000-Present
    Sunday, January 15, 2012 7:05 PM
  • 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

    Friday, January 24, 2014 7:31 PM
  • You can right click the line you created and select 'Send to back'
    Saturday, April 05, 2014 12:08 AM