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

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

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

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

Regards,
Peter T

"Joseph" wrote in message
...
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

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

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

"Peter T" <peter_t@discussions wrote in message
...
That is the default behaviour and AFAIK there is no way to change that.

Regards,
Peter T

"Joseph" wrote in message
...
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