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

  • Thread starter Thread starter Joseph
  • Start date Start date
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
 
That is the default behaviour and AFAIK there is no way to change that.

Regards,
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
Chart sizing 1
Z order problems 1
adding to Context Menus in Excel 2007 6
Excel 2007 Charts & Memory Leak?? 7
Excel 2007 chart line width + axis labelling with VBA 6
Array of Charts in Excel 7

Back
Top