Control Z-Order of drop lines in an Excel 2007 chart?

J

Joseph

Can anyone describe for me the procedure for changing/controlling the z-order
of drop lines relative to the plotted data in an Excel 2007 chart?

I would like for the chart's drop lines to remain active, but appear behind
the plotted data. The default display for drop lines seems to be on top.

Thanks!

Joseph
 
P

Peter T

That is the default behaviour and AFAIK there is no way to change that.

Regards,
Peter T
 
P

Peter T

Maybe play around with the formatting, eg

dim dl as DropLines
Set dl = ActiveChart.ChartGroups(1).DropLines
dl.Border.LineStyle = xlDash

look at weight & colour too

Peter T
 

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

z-order of various lines and bars in an Excel 2007 chart 0
How to change order of drop lines relative to the plotted data inExcel 2007 chart 0
Move Chart with Text 0
Data points in chart incorrect 0
Chart disappearing in Excel 07 but not in 03 2
Is this a bug in excel 2007 charting 9
Userform on top z-order? 3
Chart Rendering incorrectly in newer release of MSO 2007 12.0.6514 0

Top