Move bar chart to behind lines
 

I have a chart which holds a bar series and two line series. The bar
series is displayed behind the lines (ie, they are drawn across the
front of the bars) but I would prefer it if they were drawn behind the bars.

I have searched but have been unable to find a way to achieve this. Is
it possible?

--
F

Hello,

It depends on the version of excel you have.

For Excel 2007,

Click on your chart.

Click on the design Ribbon.

Click on Select Data button in the Data Group on the left.

Select the Line Series in the Legend Entries (Series) area on the left of the Select Data Source Dialog Box.

Click on the Up and Down Arrows to move your Line series into the right position. Clicking up arrow will move it in front of the other series and moving it down will move it to the back of the other series.

Let me know if this helps.

Thanks

Steve=True