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

"Joseph" <(E-Mail Removed)> wrote in message
news:4496AFC2-105D-42C4-90D8-(E-Mail Removed)...
> 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
>
>
>
>

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
news:(E-Mail Removed)...
> That is the default behaviour and AFAIK there is no way to change that.
>
> Regards,
> Peter T
>
> "Joseph" <(E-Mail Removed)> wrote in message
> news:4496AFC2-105D-42C4-90D8-(E-Mail Removed)...
>> 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
>>
>>
>>
>>
>
>