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
 
Back
Top