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

Chart disappearing in Excel 07 but not in 03 2
Excel 2007 Chart Update While Macro Is Running 4
Finding the Y-Value of Points 6
Different chart sizes between Excel 2007 and previous versions 4
How to change series plotting order without changing legend order? 6
Scatter chart does not refresh: HELP 2
Excel 2007 Chart colorindex? 5
How to create Drop down list in Chart? 2

Top