Prev: Validation on InputBox()
Next: Printing
From: Joseph on 1 Apr 2010 19:28
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




From: Peter T on 2 Apr 2010 07:10
That is the default behaviour and AFAIK there is no way to change that.

Regards,
Peter T

"Joseph" <Joseph(a)discussions.microsoft.com> wrote in message
news:4496AFC2-105D-42C4-90D8-061C316618C7(a)microsoft.com...
> 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
>
>
>
>


From: Peter T on 2 Apr 2010 07:20
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(a)discussions> wrote in message
news:evt2HUl0KHA.364(a)TK2MSFTNGP02.phx.gbl...
> That is the default behaviour and AFAIK there is no way to change that.
>
> Regards,
> Peter T
>
> "Joseph" <Joseph(a)discussions.microsoft.com> wrote in message
> news:4496AFC2-105D-42C4-90D8-061C316618C7(a)microsoft.com...
>> 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
>>
>>
>>
>>
>
>


 | 
Pages: 1
Prev: Validation on InputBox()
Next: Printing