z-order of various lines and bars in an Excel 2007 chart

I

icystorm

What is the procedure for changing the z-order of various lines and
bars in an Excel 2007 chart, such as drop lines, high-low lines, up/
down bars, and error bars?

I observed that when I add drop lines to an Excel 2007 chart, they
appear in front of the underlying data -- in my case, the underlying
data is displayed as a plotted area. I want the plotted area to be
fully visible with no lines over it.

I would like to send the drop lines to the back and keep the plotted
area in the front, but there is no option to do this.

So, is there a procedure for adjusting the z-order of drop lines in an
Excel 2007 chart?

Thanks kindly.

Cheers,
Joseph
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change order of drop lines relative to the plotted data inExcel 2007 chart 0
Control Z-Order of drop lines in an Excel 2007 chart? 2
Trendline Not Appearing In Chart Problem ? 0
Convert Error Bars to Series and Colour 1
Copying Excel 2007 chart to Word 2007 - only half of it shows 2
Excel 2007: continuously update scatter chart from scroll bars 1
Bizarre chart behaviour when changing axis cross at points 2
Labeling contour lines in surface plots? 0

Top